How do I import items from a spreadsheet?

Use this guide to quickly upload a list of items into XSite.

Step-by-Step Instructions

1. Sheet Name: The worksheet containing your items must be named ‘items’.
2. Column Formatting: Each column in your spreadsheet must be organized as follows to match XSite’s import structure:
   • Column A: PLU
   • Column B: UPC.
   • Important: For Bulloch sites, omit the last digit.
   • Column C: Part Number
   • Column D: Description
   • Column E: Supplier Name
   • Column F: Department ID Number
   • Column G: Subdepartment ID Number
   • Column H: Department Description
   • Column I: Price (Ensure to input numbers only)
   • Column J: Unit of Order (Use ‘EA’ for each, ‘CT’ for carton)
   • Column K: Case Size
   • Column L: Cost (Numbers only)
   • Column M: Deposit (Input numbers only; if no deposit is required, enter 0)
   • Column N: Tax (Enter 0 for no taxes, 1 for TAX1, 2 for TAX2, 3 for both TAX1 and TAX2)
3. Important Considerations:
   • Commas: Ensure there are no commas within any part of the file, as they will be interpreted as additional columns and could disrupt the import process.
4. Here is an example of a properly formatted spreadsheet:
   • ItemsTemplate