Store Order Import

Follow

Navigate to Utilities → Import → Transfer Order Import

2023-02-03_11_58_21-Window.png

You'll need access to a spreadsheet program that supports CSV files such as Excel or Google Sheets. Any other file type will not import.

You can download the sample template by clicking on the Download Sample link.

2023-02-03_11_59_55-Window.png

The mandatory fields for import will be preselected, you also have the option to select the other required fields and download the CSV file sample.

Now, when you are ready with the import file, process it with the steps below.

Importing Store Orders

  1. Go to Utilities → Import→ Click on Transfer Order Import.
  2. Upload Your File: Attach the Item file by simply Drag & Drop or uploading your CSV file directly from your computer by browsing for it.
  3. Click Continue when done.2023-02-03_12_13_57-Window.png
  4. Column Mapping: Once the file is loaded the column headers from the file will be displayed below the heading ColumnName. In the case of the column header from the file exactly matching the Console field name this will be automatically mapped and this is displayed in the Map to Field.
  5. You can map and make sure all of the column field data you're importing has been matched to its equivalent setting on Console.2023-02-03_12_15_35-Window.png
  6. Enter the email address to which you will receive the status of your import.
  7. Click Continue.2023-02-03_12_17_27-Window.png
  8. The Import will be Initiated → Click Finish.
  9. You will be taken back to the Import page, where at the bottom you can see a section 'Recent Imports' which will show the details and current status of the imported file.
  10. Click on the Status (highlighted in blue color) to view the Status Report- This will list both Imported Records as well as Failed Records with a reason for the failure. You also have the option to  Download the Failed Records by clicking on the Download button. You can correct the remaining failed record and precede to reimport them.
  11. Once done, you can see the Status as COMPLETED

Sample Import File Format

2023-02-03_12_12_40-Window.png

Source ID: ID of Store/Warehouse the order is requested from

Destination ID: ID of Store/Warehouse the order is requested to

Source Type: Enter S for Store or W for Warehouse

Destination Type: Enter S for Store or W for Warehouse

ItemID: Unique ItemID of the item

Quantity: Quantity of items ordered

UOM: Name of UOM

 

 

Articles in this section

See more
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.