If your brand uses an Electronic Order form or spreadsheet to enter orders, it is possible to view that data visually using Elastic!



Import your file into Elastic

 

1. To import the file, you must first 'Create a new order'. Select the Catalog that is related to your order form or spreadsheet. For instance, if your spreadsheet contains Spring '20 data, I should select the Spring '20 Catalog when creating your order:



2. Click on the Select button in the top navigation to go to the Select page, then select Menu in the top-right corner and choose ‘Import a File’:


3. Follow the instructions in the Wizard and click 'Next'. 


*Note: there are two ways to import a file: "Copy/Paste" and "From File".



"From File":


4. On the next screen, you’ll be presented with a number of options for importing your file. Depending on how your file is formatted, you may select different options to match it, you may also need to scroll down to see the file sele:

A. Column Separator - This will usually be TAB. If your file has a different separator, select it here. 

*Note: If you are using the 'From File' method, you'll want to select COMMA. If you are using the 'Copy/Paste' method, you'll want to select TAB.



B. Columns - Take careful note of where your UPC and Quantity columns are in your file. These are the only columns that will be read by when your file is imported.

C. Headers - Setting this to NO will cause Elastic to import all the lines in your file. If your file has headers, as it does in the above example, set this to YES so Elastic ignores the first line.

D. File - Select the file from your computer.



"Copy/Paste":

This method works well if you have an offline order form with multiple ship dates/locations. 

*Note: Remember that you'll need to create however many new shipment tabs on your order that have on your offline order form.

5. Repeat step 4, keeping in mind that you will Copy & Paste your file manually in the FILE section (D) instead of upload a file. Keep in mind that you need to select a specific Shipment/Order tab if copying into a specific shipment. 



6. Click 'Next', and your file will begin uploading. 


*NOTE: Make sure that the UPC numbers are not in scientific notation. If they are, click HERE to learn how to change this in Excel.



Learn how to Export an XLSX HERE.