You can connect your store to Inventory Planner with CSV connector even if Inventory Planner does not directly support your e-commerce platform. This is done with special TSV/Excel files which you make available via Google/Drive Dropbox or a web server. This file needs to be kept up to date on your side and Inventory Planner will automatically sync the data daily. 

When you connect your store via CSV connector you will need to provide 3 TSV/Excel files:

  • Products file
  • Sales orders file
  • Purchase orders file (optional)

Sales orders define the demand for your products and are used to compute replenishment suggestions when combined with current stock from products file and on order quantities for your suppliers from purchase orders file. Note that you can also choose to omit purchase orders file and manage purchase orders in Inventory Planner if your e-commerce system does not have them.

When setting up CSV connector, you should provide 3 permanent URLs for these files. These URLs should not require authorization. If you use Google Docs/Drive or Dropbox, make sure to set up permissions so that anyone with the link can edit the file. Inventory Planner will automatically access these files every day.

These files must always contain all products and orders (not only updated). If a product or a sales order is removed from files it will be deleted in Inventory Planner as well.

Product file specification:

product_id - product ID (required)
title
- product title (required)
price
- retail price (required)
SKU
- stock keeping unit (required)
created_at
- product creation date, e.g. 2016-03-28 (required)
stock_quantity
- inventory quantity (required)
regular_price - retail price without discount
cost_price - product cost price
barcode - product barcode (e.g. UPC)
updated_at - last updated date of a product, e.g. 2016-04-28
managing_stock - true if you manage inventory for this product, false otherwise
vendor - product vendor
permalink - product URL
categories - product categories, e.g. women,dresses
image - product image URL
brand - product brand
options - product options, e.g. "Color=Red,Size=X"
tags - product tags, e.g. dress,last collection
vendor_reference - vendor product SKU
moq - minimum order quantity
uom - units of measurement

TSV example
Excel example

Sale Order file specification:

order_number - order ID (required)
product_id
- product ID (required)
SKU
- product SKU (required)
date
- order creation date, e.g. 2016-03-28 (required)
price
- product price (required)
quantity
- product quantity (required)
canceled - true if order is cancelled, false otherwise

TSV example
Excel example

Purchase Order file specification:

po_id - purchase order ID (required)
po_name - the display name of purchase order (optional)
vendor
- the vendor of purchase order (optional)
date
- purchase order creation date, e.g. 2016-03-28 (required)
expected_date
- purchase order due date (required)
product_id
- product ID (required)
SKU
- product SKU (required)
cost_price
- product price (required)
status
- purchase order status, e.g. open, partially_received, closed (required)
ordered
- ordered product quantity (required)
received
- received product quantity (required)

TSV example
Excel example

Did this answer your question?