Etsy Integration

JDM Premier Plus allows you to import sales data from Etsy.  You can download a CSV file from Etsy with details of each order.  The customers and order will be added to JDM Premier and Jewelry Piece Inventory updated.

Important!  The import cannot be reversed. We recommend that you back up your data before importing in case you want to go back.

Export sales data from Etsy

1. Log in to your Etsy account and go to Orders.  At the bottom of the page click on:  Download a CSV file.

2. On Download Shop Data form select Order Items and date range. Click on Download CSV  and save the file to a folder on your computer.

Export sales data from Etsy

Add Etsy Listing ID to Jewelry Pieces

Each Jewelry Piece that is listed on Etsy must have the Etsy Listing ID entered on the Jewelry Assembly Pricing form.  If there is not a matching ID then the sales data will not be imported.

You can find the Listing ID on the CSV file and when you view the Etsy listing. The ID will be listed in the URL.

Add Etsy Listing ID to Jewelry Pieces

Import Etsy Order Items

Important! The import cannot be reversed. We recommend that you back up your data before importing in case you want to go back.

Open JDM Premier Plus and go to Preferences – > Import Etsy Data.

Click on Import Etsy Sales Order and locate the CSV file.  Select Open.

The file that will be imported will open.  Any items that do not have a corresponding Etsy Listing ID in JDM will be highlighted in Red and will not import. Click on Cancel to add the listing ID’s to all jewelry pieces on the spreadsheet and import again..

Please note that the Buyer field is imported into the Customer first name and last name. The Ship Name field will be imported into the Ship To field.  There may be orders where the buyer and ship to are different people.  If the Buyer field is incomplete you may want to edit the spreadsheet so that the fields import with more information in JDM.  For example: the buyer name in the Etsy CSV file may be:  B(Barb123).  Only B will be imported into the First Name field in Customer. You may leave it as is or change the B to Barb. – it’s up to you.

Click on OK to import.  The customers and invoices will be added to JDM and jewelry piece inventory will be updated.

Import Etsy Order Items

Pin It on Pinterest