To import/export product inventories, go to Catalog > Product from the Storefront module menu. Click on the Import or Export link. Then select "Product inventory"
Column
|
Type
|
Data required
|
Description
|
Example
|
Act
|
String
|
Yes
|
Type of import action to perform (Insert = i, Update = u, Delete = d)
|
u
|
WarehouseID
|
Integer
|
Yes/No
|
Database object identifier. This value is required when performing an update or delete action if the WarehouseKey is not provided.
|
98
|
WarehouseKey
|
String
|
Yes/No
|
A unique key that can be used to uniquely identify this object. This could be a short meaningful text or simply a GUID. If you don't specify a value, the system will generate a unique key for you during insertion. This key can be used to lookup the object if the WarehouseID is not specified.
|
westcoast
|
Inventory
|
Integer
|
No
|
|
|
MaxInventory
|
Integer
|
No
|
|
|
MinInventory
|
Integer
|
No
|
|
|
ProductVariantID
|
Integer
|
Yes/No
|
Reference the corresponding product variant by its ProductVariantID. If you specify ProductVariantID, the ProductVariantKey will be ignored.
|
|
ProductVariantKey
|
String
|
Yes/No
|
Reference the corresponding product by its ProductVariantKey. If you specify ProductVariantID, the ProductVariantKey will be ignored.
|
|