Stocktakes can be imported into Maropost Commerce from a CSV file to quickly update your stock levels to their correct amounts. You can import up to 10,000 lines, and include multiple warehouses in a single CSV file.
Please Note: The Maropost Commerce Cloud Inventory add-on is required to import stocktakes.
In this Article
Count Stock
When you import a stocktake into Maropost Commerce the stock count replaces the existing warehouse quantity. So it’s important that your counting is accurate before it’s imported.
Important: Sales orders that have been picked should not be included in the stocktake. Once an order is picked the stock is no loner part of the warehouse quantity calculations in Maropost Commerce.
To ensure accuracy there are a number of free applications that can help you count stock easily which can export a CSV file:
| Application | Platform | Export Format |
|---|
| Stock Count (recommended) | Android | CSV |
| Barcode to Sheet | Android, iOS | Excel, CSV, XML |
| Barcode To CSV | Android | CSV |
| Mobile Inventory | Android | Excel, CSV |
| Ocra Scan | Android, iOS | Excel, CSV, XML,HTML, JSON |
You can also use the product export wizard to create a CSV file of all your products. It can then be divided into separate parts and assigned to staff to count stock. We recommend exporting the below fields:
- SKU
- Name
- Brand
- Specifics
- UPC/EAN
- Pick zone (use this to sort and divide your CSV file)
Tip: Exclude variation and kit parent products, as they cannot be added to a stocktake.
Import Stocktakes
Once you’ve counted stock and have the data in a CSV file it can then be imported into Maropost Commerce. Stocktakes that you import will be marked as completed, so you will not be able to edit the figures afterwards. An import template with all fields can be found here.
Tip: To import a stocktake you need to have the Access Control > Products > Stock take permission enabled in your staff permission group.
To import your stocktakes:
-
In your Maropost Commerce control panel navigate to Stock control > Stocktake.
-
Click the Import completed stocktakes from CSV button to start the import wizard.
-
Upload your file by dragging and dropping it into the pop-up window. Or click in the pop-up to browse to your completed stocktake CSV file. Click the Next button.
-
Choose a field mapping template:
- Select an existing template that you’ve already created.
- Create a new template to import the same file format again in the future. Enter a name for your template if you select this option.
- Import the stocktake using a one-off field mapping. The mapping you create won’t be saved.
Click the Next button to continue.
-
Map the fields in your CSV file to the stocktake fields in Maropost Commerce:
| Field | Description | Notes |
|---|
| Stocktake Name | This appears in the list of stocktakes so that you can identify them once imported. | Can be set to a static value, or the system default (warehouse and date). |
| Location ID | The unique ID of the warehouse in Maropost Commerce. The stocktake will be completed for this location/warehouse.
Can be set to a static value if the stocktake is for one warehouse. | Only one of Location ID and Location reference is required in your file. |
| Location reference | The unique location/ref of the warehouse in Maropost Commerce. The stocktake be completed for this location/warehouse.
Can be set to a static value if the stocktake is for one warehouse. | Only one of Location ID and Location reference is required in your file. |
| Product SKU | Stock keeping unit. Unique identifier to match the data in your CSV to the product in Maropost Commerce. | Only one of Product SKU, Product ID, Product barcode and Product supplier SKU is required in your file. |
| Product ID | The ID of the product assigned by Maropost Commerce automatically. Found in the URL of the product. | Only one of Product SKU, Product ID, Product barcode and Product supplier SKU is required in your file. |
| Product supplier SKU | Supplier SKU field entered on the product. | Only one of Product SKU, Product ID, Product barcode and Product supplier SKU is required in your file. |
| Product Barcode/UPC | Matches against all UPC/EAN fields entered on the product, in order (e.g. UPC/EAN before UPC/EAN1). | Only one of Product SKU, Product ID, Product barcode and Product supplier SKU is required in your file. |
| Counted quantity | The amount of stock counted for each product. | Multiple counts of the same product in one CSV file will be added together during import. The count total will overwrite the warehouse quantity when imported. |
Click the Next button to continue.
-
Your file will be validated against the mapping. Any errors will appear and you’ll be able to update your mapping or correct your file and upload a new one. When your file is validated successfully you’ll get a preview of the number of rows and stocktakes that will be imported.
Important: While your CSV file can have up to 10,000 lines, a single stocktake is limited to 2,000 once created. So even if you’re import is for a single warehouse it may get split into multiple stocktakes when imported.
-
Click the Confirm and import button. Your stocktake will be imported into Maropost Commerce, and the stock levels updated to match the counts in your file.
You can now click on the imported stocktake(s) to view the results.