There may be occasion where users may use a third party website to receive orders, that are then manually entered into ePrint to process as jobs. If the third party site allows you to download the orders as a csv file, then these can be uploaded into ePrint for production & invoicing using an add on function for order imports.


If you require this add on function please contact support@hexicomsoftware.com and ask for our assistance.


In order to successfully upload orders, the following must occur;

  • The product must exist in the ePrint product catalogue
  • The product name on the order must match exactly to the product name in ePrint.
  • The Item code on the order must match the product code in ePrint.
  • The order import file, must be a .csv file and the columns may not be removed or renamed. (this file is attached to this article)


1. Click the Settings cog wheel (top right corner), then select ePrint eStore.



The window is arranged with a navigation pane on the left-hand side of the screen.


2. Click Import Orders, then Edit Style Sheet.



3. Click Change to select the eStore to Import Orders to.




4. Click Choose File, then browse to locate the file containing the orders.

Note: The sample file is attached, to add your orders to.

  • Columns A, Y and Z are mandatory.
  • Do not edit, add, remove, re-order or delete any columns.
  • It must be saved, & uploaded as a .csv file type.
  • The file cannot contain formulas and must not be formatted e.g. no currency formatting applied.

9. Click Save.

It will take up to 10 minutes for the upload to complete.


Note: 

When importing orders, the import spreadsheet provides the details for First Name, Surname and email address. 

If you import the spreadsheet and there is an existing email address in the CRM, the First Name and Surname fields will update in the CRM to match the information that is entered on the import spreadsheet. 


If the order number column (Column A) has a number that has already been used in a previous import then the order will be rejected. This column can have the same number in the same import, which creates a second item in the order. 

If you have any further questions, please contact Support.