| Table of Contents |
|---|
...
- From the Control Panel go to File Upload/Download (Administration > File Upload/Download)
- Click the Upload Files tab and select Catalogue Items File from the dropdown menu
- Click Browse and select the file you want and click Open
- Select the appropriate option from the Action dropdown
- Create New Catalogue Version: Creates a new catalogue which will become active by default, changes appear on the website straight away (recommended)
- Modify Existing Catalogue Version: Appends new items to the current active catalogue version in Ecommerce > Catalogue Versions
- Perform validation and display errors: Reads the file and checks for any errors and displays them (recommended before an upload)
- Check or uncheck the Set Version Active checkbox
- Checked: New catalogue will be active and available on your website once the upload is complete (recommended)
- Unchecked: New catalogue will be inactive and will need to be turned on in Ecommerce > Catalogue Versions
- Enter a descriptive name into the Catalogue Version Name field
- Click Upload
- The Catalogue Item File is uploaded and immediately processed
...
- Once complete you can view the upload messages, this will inform you of any errors during processing
...
Freight File
You can download a copy of your existing Freight matrix from the Control Panel under Ecommerce > Freight.
...
- Open your Freight File in Microsoft Excel and fill in the Freight File’s fields with relevant information
Fields highlighted in grey shading with bold text in the table below are mandatory fields and must contain data
Field | Description | Example Value |
FreightName | Freight text value viewable to the customer during the checkout process | Standard or Express |
FreightMethod | Internal Freight rule name viewable in the Control Panel | Freight-Melbourne (V1) |
EffectiveType | How the freight will be restricted e.g. POSTCODE or COUNTRY | POSTCODE |
EffectiveCode | Value for the EffectiveType e.g. 5000-5100;5400-5999; (POSTCODE) or ;NZ; (COUNTRY) | 3000-3210; |
UseFlatRate | 1 (Use a flat rate) or 0 (Use a calculation) for Freight | 0 |
UnitType | 1 or 0. | 1 |
UnitCost | Cost for each unit on top of BaseAmount e.g. $2.50 Cost for each item in cart | 2.50 |
BaseAmount | Base cost for Freight before adding Unit Cost e.g. $15 | 15.00 |
BreakType | the type of freight rule e.g. COST, FUNIT, PUNIT or X | COST (Price) FUNIT (Weight/Cubic) or CUNIT (Count) |
BreakLowerLimit | The starting or lowest value for the rule e.g. 0 kgs or grams | 0 (0 kgs or grams) |
BreakUpperLimit | The ending or highest value for the rule e.g. 3 kgs or 300 grams | 3 (kgs) or 300 (grams) |
Active | 1 (sets the rule active) or 0 (if BuyerSpecific is being used) | 1 |
TaxPercent | The tax rate for the Freight rule (should be 10 for GST) | 10 |
BuyerSpecific | If the Freight rule will be manually assigned to buyers in Manage Buyers | 0 |
Upload a Freight File
Buyer File
...
Please extract the customers from your accounting system and add the data to the buyer file format. Once complete please return the buyer file to us for review.
...