For more information on Capacity Planner click here
Additional steps before saving a Capacity Import file
There are some saving formats that must be used when saving your files, we will detail these steps below.
- For the "product.supplier_sku" header you must right click on the cell and change to "Number" with 0 decimal spaces. Please note this should only be done for SKUs containing numbers.
- For the "segment.from_datetime" and "segment.to_datetime" headers you must right click onto the cell and change to "Custom" with the type set to "yyyy-mm-dd hh:mm:ss". Setting this will ensure the correct datetime the platform expects is going to be received from the import
CSV Import Format Requirements
If using Excel, the file must be saved as a .CSV.
If using OpenOffice or equivalent, save as .CSV and be sure to:
Enable 'Edit the Filter Settings'
Keep Current Format
Change the character set to UNICODE (UTF-8)
The saving delimiter needs to be ","
Enable 'Quote all text cells'
The file can then be imported.