Start a conversation

Inventory updates

> What is the easiest way to upload inventory prices and qty chnages
> daily without affecting the website such as product links,
> feature products etc

The best and easiest way is to use "Update inventory" screen there you can update product prices and inventory levels from simple text csv file.

-----------

To update price you need a file in the folowing format:

productcode1, price1
productcode2, price2
...

Example:

305873-001, 15.95
36L8683, 125.95
....

Basicaly this is the same file you are using for product import but with all columns removed but 2 (productcode and price)

-----------

To update qty available you need a file in the folowing format:

productcode1, qty1
productcode2, qty2
...

Example:

305873-001, 5
36L8683, 8
....

Basicaly this is the same file you are using for product import but with all columns removed but 2 (productcode and price)

----------

To import new products into the store, you will need the same file you are using right now, but with "ONLY" new products inside.

You do the import as usuall, but without checking "Drop all products before import" checkbox. This way your existing products will not be changed and new products added to the store.

----------

Please backup your database before every update.
Let us know if you have any problems.
Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Admin FinestShops

  2. Posted

Comments