In MicroBiz v2, we now have the ability to import your sales history using the template attached.
For the beginning, Please use the correct mappings:
Import Settings
Select Register – you must select a not in use register and the register
will remain ‘locked’ and in use while the import is running.
Sales will be imported into the store the register is assigned to –
so separate your import files by store and select a register
assigned to the correct store when you import.Customer ID - this is the MicroBiz ID or any Alternate ID we will use to try and match the customer in the file to an existing MicroBiz customer.
Default Customer – if we cannot find a match to an existing using the customer id in the file – this is the customer that will be attached to the sale.
Please note: Do not modify or change any of the headers of the templates or add custom columns.
The following chart provides more information on the import fields:
| Field | Required? | Default Values | Allowed Vales | Description | Notes |
receipt_no | Y | ascii DEC 32-126 | This ID is used to group lines into a single transaction | The receipt number of the sales transaction. Receipts numbers will be altered slightly to prevent duplicates in cases where receipt numbers begin 'SAL' (MicroBiz v1) 'IMP' will be substituted for the number. | |
| customer_no | N | If left blank, Default customer record will be used | ascii DEC 32-126 | Customer Number(ID) under which transaction will be registered. If customer id not found, sale will be registered under "Customer not on file " record | |
| transaction_date | N | YYYY-MM-DD HH:MM:SS | date where transaction was registered | Must use date format selected in company settings | |
transaction_total | Y | 0-99999999.99 | 2 decimals, all lines for this transaction MUST sum to this amount qty x (selling price + item tax) | The total of transaction If receipt is a return, use - sign at the beginning | |
total_tax | y | 0-99999999.99 | All item tax lines for this transaction must sum to this amount | Total taxes collected. If receipt is a return, use - sign at the beginning | |
cashier | n | ascii DEC 32-126 | if not supplied user that ran the import will be used | ||
sales_person | n | ascii DEC 32-126 | If not supplied cashier will be used | ||
sku | y | ascii DEC 32-126 | Sku of the product used in the transaction. | If SKU does not exist in MicroBiz v2, mbz_system_not_on_file_sku will be used | |
line_description | y | ascii DEC 32-126 | Product name | If not supplied SKU name will be used | |
item_cost | y | 0-99999999.99 | Replacement cost of the product | If not supplied and SKU is found current average cost is used | |
selling_price | y | 0-99999999.99 | Price that was used in the transaction to sell the product | Can be up to 4 decimals | |
retail_price | y | 0-99999999.99 | Retail price of the product | If different from selling price difference must be the same as the sum of discounts and markdowns | |
quantity | y | 0-99999999.99 | Number of items sold/returned – negative value indicates a return – positive value indicates a sale. Can be fractional quantity if the product record allows fractional sales. | ||
item_tax | y | 0-99999999.99 | Amount of tax for the product in the transaction. | If no tax is applied enter 0 – total taxes for each item on the line |
General Notes
Only Sales and returns of products and services are imported. Order deposits, gift card purchases and any other activity is ignored. All payments are listed as ‘imported receipt’ so no payment detail is included in the import.
Inventory is NOT updated.
Each line in the file represents a line on a transaction. Lines are grouped based on the Receipt No field.
All the lines in a transaction must sum to the transaction total field using a sum of all the lines qty x (selling price + item tax)
A payment type of ‘receipt imported’ is used for all imported transactions.
It is recommended that products, and customers are imported first so we can attempt to match the sku and the customer id with the existing customers in your data.
Customers are matched based on the customer id selected in the import settings screen
If the customer is not found the sale is imported using the default customer
Whether the selling price in the file is tax inclusive or exclusive is determined by the company settings.