Kizing
Docs menu

Supplier Stock Feeds docs / Feeds

Quantity rules

Turn "In stock", ">10" or "ausverkauft" into numbers; set buffers, case packs, missing-product rules, filters, prices and locations.

Text values

Out of the box, common words in English, German, French, Spanish, Italian and Dutch are understood:

  • Out of stock words ("sold out", "ausverkauft", "épuisé", "agotado", "uitverkocht", "esaurito") mean 0.
  • Low stock words ("low", "wenig", "faible", "poco", "weinig", "scarso") mean 1.
  • In stock words ("in stock", "lieferbar", "en stock", "disponible", "op voorraad", "disponibile") mean the number you set (10 by default).

Add your own words under Rules → Text values.

Ranges and symbols

">10" counts as 10, "5-10" as 5, "<5" as 1 by default (you can choose the upper bound minus one instead). Thousand separators such as "1.234" are read correctly. Negative numbers count as 0.

Case packs

If the supplier counts cases and you sell units, set Multiply by: 12 cases of 6 becomes 72.

Safety stock

Hold back a number of units from Shopify so a late file doesn't oversell: with a buffer of 2, a supplier quantity of 10 shows 8.

When a product disappears from the file

Choose per feed: leave stock as it is (default) or set stock to 0. Kizing never unpublishes or deletes products. Rows a filter leaves out and products tagged to be left alone never count as missing.

Filters

Under Rules → Filters, take only some rows from the file: "Brand is Acme", "Category contains garden", "Status is not discontinued" (up to three conditions; all must match). Add tags under Never change products tagged to keep products out of the feed, for example stock you make yourself. The run log counts the rows and products left out.

Prices and cost

Under Rules → Prices, a feed can also use the supplier's prices:

  • Cost per item from the file's cost column.
  • Selling price from the file's price column as it is, or from cost plus your markup (a percentage and a fixed amount), rounded to .99, .95 or a whole number if you like.
  • Compare-at price from the supplier's recommended retail price, when it is above your selling price.

A price is never set below cost, and a price that would fall more than 50% (you can change the limit) is held back and listed, because that is more often a wrong column than a real price cut. Every dry run lists each price change next to the stock changes. Cost is written to Shopify with the stock; selling and compare-at prices are written only in stores that have given Kizing permission to edit product prices, and are shown as a preview otherwise.

Locations from the file

If the file lists stock per warehouse (a column such as "Warehouse" or "Lagerort"), map that column, run a dry run, and choose under Rules → Locations from the file which Shopify location each warehouse goes to. Several warehouses can go to one location; their stock is added up. Choose Skip for a warehouse you don't sell from. Rows for a warehouse you haven't mapped are listed and not used. Until you map one, every row goes to the feed's location as before.