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:

Did this answer your question?