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
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
To ensure accuracy there are a number of free applications that can help you count stock easily which can export a CSV file:
| [Table content - full table support coming soon] |
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
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
Access ControlProductsStock takeTo 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:
| [Table content - full table support coming soon] |
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
- 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.
