Special characters

Special characters are allowed as part of the name of the item, department, category, subcategory, size, color, style, brand, season, and vendor

The allowed special characters

/  &  #  (  )  +  '  "


Not permitted:   !   ,  _  %   ?   @ ; : $ < > [  ]   û (the circumflex on the u)

Also, Not permitted on Vendor (Supplier Name):  -   .  &


Max characters

Max characters in any field is 50. If you have any fields longer than 50, you will receive a prompt. You can then choose YES to truncate the items, or NO to manually find and shorten those items in your file and import again.


Selling Price

If you are are creating the import file and some items have a selling price and others are unknown at this time. Put 0.00 for the ones where you do not know the selling price (do not leave blank).  

Omit the "$" as part of the cost and selling price


Note: If these items are sold and the selling price is $0.00 the cashier will have a pop up asking what is the selling price. This is our Variable pricing option, which is also often used for those items that are sold at different prices regularly


Sales Tax on your Items

Your default sales tax will be automatically applied to your items unless you specify on the import file differently. 

If the tax should be different on some items, create a column on your import file and specify taxID.



File Formatting

Save as csv or txt file

If using our item template with all available data options, remove all columns that are not being used before sending

If using a non windows computer, save the cvs as "cvs for windows"