When importing into RetailBasics, you can't match the fields in your import file against the fields in RetailBasics. This means the file you're importing needs to contain information which conforms to the field specifications accepted by RetailBasics. These field sepcifications are basically the format of the information in each field. The tables below specify the order in which the columns needs to be, as well as the contents and purpose of the field. STAFF CARDSRetailBasics field | Description/Comments | Type | Type of Character | Staff ID # | The staff member's ID. | 10 | Alpha Numeric | Surname | The staff member's surname | 25 | Alpha Numeric | Given names | The staff member's given names | 25 | Alpha Numeric | Docket Name | Name that will show up on Receipts | 8 | Alpha Numeric | Addr1 | Address | 40 | Alpha Numeric | Addr2 | Address | 40 | Alpha Numeric | Suburb | Suburb/Town | 40 | Alpha Numeric | State | State/Territory | | Alpha Numeric | Postcode | Postcode | 10 | Alpha Numeric | Phone | You can match Phone#1, Phone#2 or Phone#3 if you choose. | 15 | Alpha Numeric | | Mobile | You can match Phone#2 or Phone# | 15 | Number | Birthday | The employees Birthday | DD/MM/YYYY | Date | Start date | The day they commenced work | DD/MM/YYYY | Date |
CUSTOMER CARDSRetailBasics field | Description/Comments | Type | Type of Character | Customer id | ID Number Of The Customer | 10 | Alpha-Numeric | First name | First Name | 25 | Alpha-Numeric | Last name | Last Name | 25 | Alpha-Numeric | Company name | Company Name | 40 | Alpha-Numeric | Address1 | Address | 40 | Alpha-Numeric | Address2 | Address | 40 | Alpha-Numeric | Suburb | Suburb/Town | 40 | Alpha-Numeric | State | State/Territory | 3 | Alpha-Numeric | Postcode | Postcode | 10 | Alpha-Numeric | Phone | Phone Number | 15 | Alpha-Numeric | | Mobile | Mobile Number | 15 | Alpha-Numeric | Fax | Fax Number | 15 | Alpha-Numeric | Email | Email Address | 40 | Alpha-Numeric | Notes | Comments | | Memo |
STOCK CARDSRetailBasics field | Description | Size | Type | Stock Code | The stock number for this item. Also used as the barcode number. | 13 | Alpha-Numeric | Department | The name of the department that this stock item belongs to. | 10 | Alpha-Numeric | Unit of Measure | The unit of measure that is used for this item. This must be an abbreviation, for example Ea for Each, Kg for Kilograms, Mtr for Metres, lbs for Pounds, etc. | 3 | Char | Tax Code | The tax code applicable to this item. | 3 | Char | RRP | The Recommended Retail Price for this item. Can all be either including tax values, or excluding tax values, but not a mixture of both. You will be prompted during the import whether your RRP prices are inc tax or ex tax. | 11; in the format of 6 digits, one decimal sign, and four decimal places. for example 999999.9999 | Currency | Description | The description for this item. | 40 | Alpha-Numeric | Up-sell Prompt | This is the message that will appear in your sale screen whenever this item is being sold. | 40 | Alpha-Numeric | Tare weight | Optional. If this item is being measured using scales, specify its tare weight here, which is the items weight less the weight of its container. | 11; in the format of 6 digits, one decimal sign, and four decimal places. for example 999999.9999 | Decimal |
| 
