Important: This article applies to the specific versions of software: X-Cart 5.2.13 and higher.
The add-on Update inventory for X-Cart provides a quick and easy way to update product quantities by importing a simple CSV file. This add-on works for both regular products and product variants.
Starting from v5.2.13, X-Cart has a full-featured import mode to update the existing items. It allows modifying your product information (including the stock quantity, price, and other product properties) using the standard X-Cart's Import feature that you can use instead of the "Update inventory" add-on.
The required CSV file format for importing product quantity information using the add-on Update inventory is as follows:
As you can see, the CSV file has just two fields:
Field in CSV file | What this field describes | Value type |
sku | Unique identifier of the product or variant | String, Max. length: 32 |
qty | Stock level, unsigned positive number if the change is absolute, and signed if the change is relative. | Integer |
X-Cart 5.3.3 and higher: You can also specify changes based on the current stock using the qty field. Mark the relative difference with the sign character, e.g. +5 (stock increase by five items) or -10 (stock decrease by ten items).
In a store with the Update Inventory add-on installed and enabled, you can import the CSV file for updating product quantities via the Update quantity section (Catalog > Update quantity):
When importing a CSV file to update product quantities, the following rules apply:
If an SKU from the CSV file does not match the SKU of any existing product or (when using the Product Variants add-on) product variant in the store's database, the error is logged, and the respective line in the CSV file is skipped.
Product quantities must be positive numbers. If you specify a product quantity in the qty field in the wrong format, the error is logged, and the respective line in the CSV file is skipped.
Any errors generated during import display after the completion of the import process.
Related pages: