Steps to walk you through how to create an excel sales order form which you can send out to your agents and customers to then import directly into Indigo8.
Step-by-step guide
How to create the Excel Form
1. Click one of the arrows on the centre bar and choose Product Search
2. Find the collection you are working on.
Select All at the bottom of the screen
Select Report > Sales > Sales Order Form
3. Select your trading entity that you want the prices to appear in. The tax will appear next to the trading entity appropriately. This will add the tax amount against the SELL EX GST price (your wholesale price).
Click APPLY for the prices to update.
Click EXPORT TO EXCEL
4. Below is how the excel file will look like.
Points to Note:
- We automatically group the excel report based on size range. So if you have many size ranges in your collection it will group the together appropriately.
- We also leave the blank space at the top so you can drag in your company logo and other details you would like your customer to enter
5. There are a few options on this report to show certain fields:
Allow to Edit Sell Price: If this is checked, this allows your customer to enter whatever price is on the excel and then import that directly into the system.
Include Images: This shows or hides the images onto the excel. Normally this is checked.
Include F1 Fabric: This allows your to insert the fabric of the garment into the "selling points" report.
Group By Product: This will organise the report based on the product category that is assigned in product search. It will be Grouped by Alphabetical Order.
Delivery: If your styles are dropped in different periods you can indicate that on the excel report. This means when importing the excel form, if there are multiple delivery periods, we will insert each delivery into a new SHIPMENT.
We recommend that you insert the word DROP 1.. DROP 2.. DROP 3 under the delivery column.
We do have the option to even go deeper and create different delivery dates per colour. You can use the "by colour" checkbox to do this.
Select SAVE once done
The text entered will appear on the far right hand side.
How to Import the Excel Form
Before beginning to import, ensure your file is XLS format not XLSX.
1. Go into the Sales Module
2. Click into the button right at the bottom called Bulk Import
Click Add Excel File and locate your file and give it a few seconds for the system to load.
3. Enter the first few letters of the customer name such as DAVID JONES and hit enter to lock it in.
You can enter all the appropriate fields such as ATTENTION, TERMS, AGENT etc.
In the file we have multiple drops so the system has detected there are few styles which have