...
The table below shows the Required, Recommended and Optional fields in CatalogueLINK Upload:
| Field Name | Description | |
|---|---|---|
Required | Product Code | A unique code for a product |
| Product Name | A descriptive name (title) for a product | |
| Category Level 1 | Primary group for a product | |
| Unit of Measure | The default unit of measure for products | |
| Standard Price | Standard price (ex GST) | |
Recommended | Item Description | A detailed description for a product |
| Manufacturer Name | The Manufacturer of a product | |
| Category Level 2 | Secondary group for product | |
| Category Level 3 | Third-level group for product | |
| Size | Size information for products, used in Product Option menus | |
| Freight Size | Used in freight calculation for product weight | |
| GST Tax Rate | Your GST Tax rate (10) | |
| Stock Quantity | The field you want to use for stock quantity measurement | |
| Use Stock Quantity | Determines whether stock quantities are displayed to customers | |
| Allow Negative Stock Quantity | Allows customers to order a product on back order (Out of Stock) on an item by item basis | |
Optional | Manufacturer Code | Manufacturer code for a product |
| UNSPSC | The UNSPSC code for product | |
| Special Instruction | Can be used as an extra description field | |
| Weight | Product weight information | |
| Lead time | Number of days before an item will be shipped | |
| Minimum Order | May be used if a minimum amount of an item must be added to cart | |
| IsHidden | Tick on if product should not be displayed on website, should be on if product is a child product | |
| Priority | Used to sort products on a list, the lower the priority value the higher it will appear |
Dynamically Update Data
The AlwaysUpdate column allows you to:
- Look for new data against item fields every time you import from your accounting system (checked)
- Look for data once and never again (unchecked)
This can speed up the import process if you are finding it is taking a considerable amount of time or if there are fields where the data will never change:
- Fields where data changes regularly such as Standard Price’ or ’Stock Quantity would be set to always update
- Data that stays constant such as Size and Weight may not need to be updated after the initial import against an item
To enable AlwaysUpdate:
- Select a FieldName row that you wish to have always update from the accounting system
Check the AlwaysUpdate checkbox in the top left hand corner and press Save
Exporting to Excel
You can export your items list to an Excel file to manipulate large amounts of data quickly when you are not importing it from your accounting system
e.g. when you are using the Enter My Own option for a field:
- Select a FieldName row
- Check/uncheck the ExportToExcel checkbox in the top left hand corner and press Save
- Optional: Enter a unique priority number in the Excel Column Export Order text box and click Save
| Info |
|---|
Note: To reset the column orders to their default values click ‘Reset Export Order to Default’ |
Importing Products
Once these fields are mapped and saved, click Import and perform our initial import of products:
...