Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Getting Your Data Ready

CatalogueLINK Upload's primary function is to connect to your accounting system and import product data from it before uploading it to your website.

...

CatalogueLINK Upload facilitates the connection of accounting system fields to website fields.

Selecting Accounting System Fields for the website

Your mappings will be setup in Setup – Catalogue Fields during the configuration session:

...

For more information: see Editing Products in CatalogueLINK

Turning Fields On or Off

To turn fields on or off:

...


Field NameDescription



Required

Product CodeA unique code for a product
Product NameA descriptive name (title) for a product
Category Level 1Primary group for a product
Unit of MeasureThe default unit of measure for products
Standard PriceStandard price (ex GST)






Recommended

Item DescriptionA detailed description for a product
Manufacturer NameThe Manufacturer of a product
Category Level 2Secondary group for product
Category Level 3Third-level group for product
SizeSize information for products, used in Product Option menus
Freight SizeUsed in freight calculation for product weight
GST Tax RateYour GST Tax rate (10)
Stock QuantityThe field you want to use for stock quantity measurement
Use Stock QuantityDetermines whether stock quantities are displayed to customers
Allow Negative Stock QuantityAllows customers to order a product on back order (Out of Stock) on an item by item basis





Optional

Manufacturer CodeManufacturer code for a product
UNSPSCThe UNSPSC code for product
Special InstructionCan be used as an extra description field
WeightProduct weight information
Lead timeNumber of days before an item will be shipped
Minimum OrderMay be used if a minimum amount of an item must be added to cart
IsHiddenTick on if product should not be displayed on website, should be on if product is a child product
PriorityUsed 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:

...

  • 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

...

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:

...

This can also be covered during the configuration session.

Importing Customers and Customer Special Pricing

CatalogueLINK Upload's other core function is to connect to your accounting system, import customer records and upload them to the CMS attached to your website.

...

  • This can be configured for all Customers in Setup – Customer Settings, individually in View / Edit or for groups of customers via Apply Data.
  • Let's begin the Import of Customers and Customer Special Pricing
  • Select Customer Information and Customer Special Pricing Information
  • When this process has completed you will see a listing of what CatalogueLINK Upload has imported.
  • Your customers should then appear in the Customer listing with a status of New (when the customer is new to CatalogueLINK Upload) or Modifying (when a product's data has changed since the last import)

Importing Invoices

The final data type we can import is Invoices.

...