Articles on: Upload/Import Files

Upload/Import Files

Download Sample


Navigation: Pos Backend → Upload/Import Files → Download Sample


Multiple records can be imported into the system using import feature.



The following buttons available on the top right corner:

  • Download Sample
  • Import File


Download Sample


Press this button to download the sample XL sheet. The following sheets are available:


  1. Categories
  2. Taxes
  3. Items
  4. Transfer Order
  5. Waste Management
  6. GRN
  7. Item Price Update
  8. Price Categories
  9. Stock Update
  10. Purchase Order
  11. Order
  12. Item Variation Update
  13. Item Inventory Tax Update
  14. Item Ingredient Update


Sample sheet contains demo data for reference. Have data in the sheets which are to be imported and delete information in the other sheets. For example, if we are configuring Taxes, Categories and Items, delete information in other sheets. After filling the required details, save and close the XL.




Note: Columns names marked with RED colour in Download Sample XL sheet are mandatory fields.

Upload/Import Files


Step 1: Press Import File button and choose the XL file to import.




Step 2: After every import, an entry is created in the table with pending **status. Wait for 10 seconds and refresh the page to see the current status. After refresh, the status changes from **Pending to the either one of the following:


  • Completed: Press View button under the Actions **column to open the **Import Information Table.
  • Error : Upload the sheet again.




Step 3 **: Once the status is **Completed press View button under Actions to open the import information. To download the uploaded sheet press Download button. The following are the columns available in Import Information.


  • Sheet Name: Displays the imported tab name.
  • Total Error Lines: No of error lines, click the lines to see the detailed error report.
  • Total Records: Total number of records imported.
  • Failed Records: Failed number of records.
  • Finished Records: Completed number of records.
  • Completion Progress: Completion progress of the import.





Updated on: 07/10/2021

Was this article helpful?

Share your feedback

Cancel

Thank you!