How to update stock or prices from a supplier file

Your store knows the products, the supplier knows the stock. Instead of copying numbers by hand, connect both and let a rule join them product by product.

1. Add the supplier file as its own data source (XML, CSV, FTP or Google Sheets) - see Connect an XML, CSV, FTP or JSON feed.
2. Open your main data source, go to Rules and click Add rule - for example “Stock from supplier”.
3. Under Then pick a new column - for example supplier_stock (New columns in the Products tab), not availability itself - and choose Match with data source.
4. Set Match this field to your key (for example id or sku), With data source to the supplier file, Its field to the same key in that file, and Take its field to its stock or price column.
5. Check Preview changes, then Save rule.

Example

• Your product: id TL-3007, supplier_stock empty
• Supplier file: code TL-3007, qty 14
• After the rule: supplier_stock 14 - and a second rule can turn 0 into out of stock.

Products that are not in the supplier file get the field emptied. That is why the rule writes into a new column such as supplier_stock and not straight into availability - otherwise their availability would be wiped. To join two catalogs into one instead, see Combine several data sources.