Updating stock
To update stock only 2 fields are needed. These fields are:
-
product_sku
-
product_in_stock
Creating the template
First create a template:
-
Go to Components ? CSV Improved ? Templates
-
Click on New
-
Click on the General tab
-
Choose Type Product import
-
Give the template a name by filling in Name
-
(Uploading CSV) Fill in the field and text delimiter
-
Click on the Import tab
-
Check the box behind Use column headers as configuration
-
Check the box behind Overwrite existing data
-
Click on the Save button
The template has now been created.
Creating the import file
The import file can either be a CSV or XLS document, the layout remains the same. Both the column names need to be specified in the file, that way CSV Improved can read the column header and know what fields to update.
On the first line we add the column headers:
product_sku | product_in_stock |
From the second line and further the product data can be added that needs to be updated:
SKU1 | 10 |
SKU2 | 8 |
SKU3 | 25 |
After all the products are added, the file in a spreadsheet will look like this:
product_sku | product_in_stock |
SKU1 | 10 |
SKU2 | 8 |
SKU3 | 25 |
The file to import has been created.
Importing the stock file
To import a file take the following steps:
-
Go to Components ? CSV Improved ? Import
-
Choose the template with the name created earlier
-
Now select the file to import under Import a CSV File by clicking on Browse
-
Click on Import
The file is now being imported and the results of the import are shown on the result page.