i) Using File/Upload Download

Catalogue Item File

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

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

Buyer File

As a part of a website project we can perform a once off upload of customer accounts. This is achieved via a Buyer File, although some additional files may also need to be provided depending on your customer records. You should populate this file with all the accounts that you want to login to the website upon launching it. See the legend below for a description of what each field is for and also the file (attached) for an example of the data we will require.

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.

The "Seller Reference" is the defining record of your customer as per your accounting system. It is very important for this to be accurate.
There may be additional fields to the ones below. These should be covered in documentation you receive from Straightsell.

Field	Summary	Example
BuyerName	The customer's company name.	Building Co
Address1	The first part of the customer's address	123 Main Street
Address2	An optional second line for a customer's address	Corner 1 and 2 Streets
City	The city or suburb	Melbourne
State	The state	VIC
PostCode	The post code	3000
Country	The country	AU
Fax	If a customer has a fax number	12348888
AdminName	The full name of the customer.	John Smith
AdminEmail	The email address of the customer. Should match BuyerUserName if using email addresses as usernames	john@buildingco.com
AdminPhone	The phone number of the customer	0499123999
ABN	Australian Business Number	123456789
BuyerUserName	The usename of the customer. Should match AdminEmail if using email addresses as usernames	john@buildingco.com
BuyerPassword	A generic password can be entered here as customers will be sent a link to set their own	Password99
BuyerType	2 for an Administrator (full access to all logged in funcitons) or 1 for a Standard User (more locked down access)	2
ApprovalStatus	1 should be set here, 0 will mean Buyers aren't approved and will not be able to login.	1
DefaultTerm	The default payment term for a Buyer. Only one can be set here.	Credit Card
RestrictView	N/A
RestrictViewBy	N/A
DefaultStore	N/A
SellerReference	Must match the customer's reference in the accounting system.	BUILDINGCO
StartPage	N/A

Payment Terms File

Field	Summary	Example
BuyerReference	Must match the customer's reference in the accounting system.	123
PaymentTerm	Match the payment term found in Ecommerce - Payment Terms	Credit Card

Delivery Address File

Field	Summary	Example
Seller Reference	Must match the customer's reference in the accounting system.
Address Name
Address 1
Address 2
Suburb
State
PostCode
Country
Special Instructions

Account Manager Assignment

Field	Summary	Example
BuyerReference	Must match the customer's reference in the accounting system.	123
AccountManagerUserName	The CMS username of the Account Manager found in Manage Users	Credit Card