2015-08-13
Rating 0 stars - 0 votes

Update PrestaShop Inventory Having Only 2 Columns in Import File

As the number of products in your PrestaShop store grows, it’s becoming cumbersome to manually update inventory levels. Import to PrestaShop is the way to perform this task faster.


This tutorial will guide you how to upload spreadsheets with quantity changes.


File Sample for Inventory Updates

First step is file preparation. In case products are already in database, to renew their stock basically you need a CSV with 2 columns: one with available product quantities and other field to identify them (in PrestaShop it is required field – Name).



If you have identical products names or in case your provider offers you the files of other formats, like XLS, XML, TXT or ODS with specific column names and values there, you can use alternative way to import stock levels to PrestaShop store.


With Store Manager for PrestaShop app you can use unique values as product identifiers, since sometimes product names coincide. This way you make sure that needed products are getting updated.


To refresh inventory of existing products with Store Manager application there is no need to import descriptions, images and all other data in case you do not need them to be overwritten. It is enough to have only 2 columns in the file: the one with product identifier (either ID, Reference number, Reference+Name, UPC or EAN) and quantity field.


Try Store Manager for PrestaShop to import inventory levels easier. Download FREE



Import of Stock Levels

After the file is ready you can use Import Wizard of Store Manager for PrestaShop. Basically, you need to:

  1. Select your file with inventory updates.


  2. Indicate characters used as data separators in your file.


  3. Map spreadsheet columns to database fields in case they are named differently. In case their names are identical, they will be auto-linked.


  4. When all the settings are set, submit the file to import into PrestaShop.


  5. Check the results.

Note: If you have Advanced Stock Management enabled and your products quantities are based on warehouse stock, you cannot import these values, as this functionality is not included yet.

Inventory of Products Not Listed in File

With Store Manager for PrestaShop it is possible to manage stock and status of products that are at your store, but not included in your import file.

You can set quantity to ‘0’ for products that are not listed in your file or even disable these items. The corresponding options you can find at the last step of import.



Automatic PrestaShop Quantity Updates

Inventory update in most cases is repeated task, so the importance of automating processes can’t be overestimated. Store Manager for PrestaShop can be extended in functionality with the range of addons. One of them, namely, Automated Product Import addon allows to set up scheduled imports to update your catalog.


The addon is built-in Store Manager for PrestaShop in Demo mode, so you can give it a try with a few product records.




Try Store Manager inventory management tool FREEGet It Now!