Bulk Create Inventories
Steps
Click on "Products" in the navigation menu.
Navigate to "Bulk Operations".
Click on the "Export" button displayed as an icon under "Create Inventories" and wait for the template to be generated.
Click on the "Template File" under operation history to download to template file.
To create new inventory items, add a new line for each item you want to create and ensure that all mandatory columns are filled in accurately. Go to Template Specification to learn more about the columns.
Upload the edited template using the upload section under "Create Inventories".
Uploaded file will be marked as "Processed" under operation history if no issues were encountered.
SKUs that have been processed succesfully will appear in Physical Inventories.
If any issues arise with the uploaded file, the 'Operation History' section will display the 'Uploaded File' and 'Issues Report.' Download the Issues Report file and edit the fields that require corrections.
Inventories that have been successfully processed are not displayed in the issues report file.
Template Specification
| Inventory name | Inventory SKU | Package Width (mm) | Package Length (mm) | Package Height (mm) | Package Weight (gram) | Package Contents | GTIN (Barcode) | Stock | Cost Price | End of Life | Free Gift |
|---|---|---|---|---|---|---|---|---|---|---|---|
Mandatory | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory | Optional | Optional | Mandatory | Optional | Mandatory | Mandatory |
Item name of the product. | Inventory SKU is a unique identifier for each physical product. Inventory should be already exist in Sellercraft **Users can do bundling by adding a row with the same variation. | Dimensions will be used to calculate the shipping fees for shipping channels. | Dimensions will be used to calculate the shipping fees for shipping channels. | Dimensions will be used to calculate the shipping fees for shipping channels. | Package weight will be used to calculate the shipping fees for shipping channels. Note: Inaccurate weight may cause inaccurate shipping fees and rejected deliveries by logistic partners. | Package Contents | GTIN is Global Trade Item Number which is a unique and internationally recognized identifier for a product. | The total number of item. | Cost price of the product. | TRUE when the item already stop for production (not active) or have new Inventory SKU for that item. FALSE when Inventory SKU for the item still active | TRUE when the item given as free gift FALSE when the item is not free gift |
Please input Min 1 - Max 20 characters for the variation name | Please choose from the drop-down box, or copy and paste SKU for inventory from “Inventory Reference” sheet. Inventory SKU that needs to be attached to the variant. | Please input Min 10mm - Max 3000mm for product width | Please input Min 10mm - Max 3000mm for product length | Please input Min 10mm - Max 3000mm for product height | Please input the whole number Min 10g - Max 300000g for package weight | Please input package contents | Please input GTIN (Barcode) | Please input stock based on the inventory. | Please input Min 0.2 to 1,000,000,000 for full price *Only positive numbers are accepted.The price must in 2 decimal places | Please input either TRUE or FALSE option for the end of life. | Please input either TRUE or FALSE option for the free gift. |
Eye Cream | EYECREAM01 | 100 | 100 | 200 | 200 | EYECREAM01 | 300 | 150.00 | False | False |
Example
When all the SKUs have been processed, your SKUs have been created!
Last updated
