Import Orders with Excel

FAQs

• What is the maximum number of orders I can submit at once via Excel?
×
What is the maximum number of orders I can submit at once via Excel?
The current limit is up to 50 orders at a time. This number may change in the future. If you have more than 50 orders, you will need to split them up into more than one submission.
Close
• What if my Excel document does not match the template?
×
What if my Excel document does not match the template?
You will have the opportunity to map your Excel document to the appropriate fields prior to submitting your orders if they do not match. In some cases, you may need to modify your Excel document prior to uploading it if the column formatting is too different.
Close
• Are all columns in the Excel template required?
×
Are all columns in the Excel template required?
Most columns are required. Our Excel module documentation shows which ones are required.
Close
• Can I provide an Excel or other type of file?
×
Can I provide an Excel or other type of file?
We recommend .xlsx or .xls files, which are the two types of Excel file extensions. Also supported are .csv files; however, be careful with .csv files since formatting issues can easily occur.
Close
• What if I don’t have Excel?
×
What if I don’t have Excel?
If you don’t have Excel, we recommend using Google Docs’ spreadsheet or even Apple’s Numbers. There are also other free spreadsheet programs out there. You would populate the spreadsheet the same way, but then export it as an .xlsx document.
Close
• What if I have more than 1 item in an order?
×
What if I have more than 1 item in an order?
You can submit multiple items within the same order by simply including the same PO for that row.
For instance, if you had an 8×10 print and a 16×20 print going to the same customer, you would duplicate the row of the first item (let’s say it is for the 8×10 print), and then change the product code or SKU in the duplicated row to reflect the 16×20 print.
Close
• How does billing and payment work?
×
How does billing and payment work?
When you set up your billing and payment methods, each time your orders are successfully received by FinerWorks, the payment method you set up within your FinerWorks account will be billed.
Close