Welcome to the One Stop Order Processing help desk



 
Knowledgebase: Other Selling Channels > Etsy
How to import your Etsy orders into One Stop Order Processing
Posted by Zoe Strassen, Last modified by Beth Rose on 14 August 2018 10:27 AM

How to import your Etsy orders into One Stop Order Processing

This feature is available in the Lite, Professional, Premium and Enterprise subscriptions of One Stop Order Processing.

The following guide will show you how to export and download the order file from your Etsy shop then import it into One Stop Order Processing.

Click here to watch the video version

You will need to log in to your Etsy account and follow the steps below

1. Click the Your Shop tab , then select Orders and then Orders again, shown below

2. Click the Download a CSV file link at the bottom of the orders page, shown below.

3. Set the CSV Type to Order Items and choose the time period that you wish to import your orders, shown below.

4. Now you are ready to import your CSV file into One Stop Order Processing.

5. Click the import button and click Add.

6. Set your import to type to Other Shopping Carts, CSV IMport (OSOP Format). 

7. Click Next and add in the file location of your CSV file that you just exported from Etsy.

8. Click Ok.

9. Set the date format to DD/MM/YYYY.

10. Tick the box that says Use OSOP Compatible Header For Import File. 

11. Select Custom Header, then copy and paste the Header Below into the field. It should then look like the Image below.

Order date,Item title,Invoice Buyer ID,Item quantity,Item price,NA,NA,Discount,N/A,Total P&P,Item tax,Item total,Currency,Transaction ID,NA,Payment date,Dispatch date,Invoice Customer,Invoice Address line 1,Invoice Address line 2,Invoice Address line 3,Invoice County,Invoice Postcode,Invoice Country,Order ID,Custom:Entered val. 1,NA,NA,Payment method,NA,NA,Total Tax

12. Now click Ok and Import your orders.

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: