When you need to order according to volume or weight of your product to fill a container or target a weight limit for shipment, then adding CBM (cubic meters) or weight of each item to Inventory Planner can help streamline your purchasing process.
CBM, net weight, or gross weight information can be entered in the corresponding field in Replenishment, or can be imported from a spreadsheet.
Add directly to the report field
In Replenishment, click the gear icon at the top of the page.
Then search columns for CBM, net weight, or gross weight column and click the column name to add it to your report.
Then you'll have a field in that column where you can enter information.
Finally, save your changes.
Import CBM information
To import CBM, net weight, or gross weight information to Inventory Planner, prepare a spreadsheet with the following information based on the information to import (ie either CBM or a weight field, but possibly not both):
SKU or other unique identifying information like barcode or ID
CBM - the cubic meters per individual unit of the variant
Net weight - weight of the individual item without any packaging
Gross weight - weight of the individual item including packaging
Each of these columns must have a column title. If they do not have a column title, the first line of data will be ignored during import. You can decide on the exact column name.
In the Replenishment screen, select Import > Variant settings.
You can see the available columns listed on the bottom of the import section.
(We also offer the ability to download a CSV template, with the available columns for adjustment)
When your CSV file is prepared and ready, you can drag the file to the import section, or click to select your file.
Once Uploaded, you will be taken to a field mapping screen, where you can check and confirm the columns on the file are mapped to the desired settings.
Click 'Import' to complete the import.
You will then see an import summary screen, that will confirm changes or if any errors were experienced during the import.
If you have any concerns, please reach to us using the in-app support chat.
CBM or Weight on your Purchase Order
Once CBM or weight values have been entered into Inventory Planner for your variants, you can enable this information on your purchase order. This will show variant CBM * quantity ordered.
To scale the total quantity on your PO to meet limits of a shipping container or other size constraints, click Actions > Scale to Total CBM.
Enter the total target CBM
And click Scale to update your purchase order.