Catalogue Item File

Owned by Oliver Fraatz
Last updated: Sept 15, 2017
Index

Catalogue File Concept

The concepts below apply for a Straightsell Catalogue File

Catalogue Management via File

The catalogue file is used by customers that have an unintegrated website and is used to manage the website inventory.

Catalogue File Management

An example Catalogue Item File with the above information can be viewed here. Once open, use the highlighted icon in the image below to download and open file in Excel.

You can download a copy of your existing Catalogue Item File from the Control Panel under Ecommerce > Catalogue Versions.

Click Create File next to the specified version of the catalogue to generate a file then click the New File Created link to download it.

  • Open your Catalogue Item File in Microsoft Excel and fill in the Catalogue Item 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

HTML can be used for the ProductDescription and SpecialInstructions fields if required. Keep field text all on one line (or one cell in Microsoft Excel) and do not use carriage returns or it will cause issues with the upload. Instead, use the <br> tag to add line breaks

Catalogue File Fields

Field

Description

Example Value

ProductCode

The code of the product

B100

ProductName

The name of the product

Corona 24 Pack Carton

ProductDescription

A description of the product, keep all descriptions on one line (65000 character limit)

This is a bottle of Beer.<br>It’s very refreshing.

CategoryLevel1

The first level category (Beer -> Lager -> Cartons)

Beer

CategoryLevel2

The second level category (Beer -> Lager -> Cartons)

Lager

CategoryLevel3

The third level category (Beer -> Lager -> Cartons)

Cartons

UNSPSC

United Nations Standard Products and Services Code

-

ManufacturerName

The name of the manufacturer

Generic Beer Co.

ManufacturerProductCode

The manufacturer’s product code

BEER01

SpecialInstructions

Can be used in addition to the description (400 character limit)

This is a second description

UnitOfMeasure

The unit for measuring an item (2 character limit e.g. EA for each)

EA

Weight  

Shows an items weight on the website (unrelated to freight)

7.92kg

Size

Shows an items size on the website (unrelated to freight)

-

FreightChargeApplies

The item weight value used for freight rules based on weight e.g. 1 for 1kg or 100 for 100g

0.6 or 600

LeadTime

Time (in days) that it will take for item to be processed.

2

MinimumOrder

The minimum number of a products that must be ordered

1

StandardPrice

The standard (regular) price of a product

3.20

GSTRate

The Tax rate for an item

10

Priority  

The higher (1 being the highest) the priority value the sooner it is shown in a category list.

10

IsHidden

Shows (0) or hides (1) a product on the website.

0

AllowStockLevels

Shows (1) or hides (0) an item’s stock balance set in StockBalance

1

StockBalance

Shows (1) or hides (0) the amount of stock on hand for the item

235

AllowNegative

Enables (1) or disables (0) backordering of items for customers

0

Upload a Catalogue Item File
  • 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