Using the Magento 2 Marketplace Etsy Connector, the admin and the sellers of the marketplace will be able to import and export their products from Etsy. After syncing the products, the specification and variations are also imported along with the products. The admin and sellers can also map categories of Etsy with the Magento 2.
When the orders are imported automatically or manually if the products are not synchronized then the products get created automatically. The extension also supports product information update from Magento to Etsy store.
Note: This extension is an add-on to the Multi-Vendor Marketplace. To make use of this extension, you must have first installed the Webkul’s Magento 2 Multi-Vendor Marketplace.
- The admin & seller can import and export products from Etsy.
- Simple, configurable, grouped and bundle products are exported.
- The admin & seller can import orders from Etsy.
- The admin & seller can map categories of Etsy.
- The admin can allow using his mapped categories.
- Assign imported products to correct Magento category.
- The admin can add multiple seller Etsy accounts form the admin back-end panel.
- Synchronized Etsy product work like same as Magento marketplace product.
- The product can sync with Specification and Variation.
- Import Etsy orders according to selected dates.
- Select default website for importing products.
- Select Attribute Set ID for each Etsy account.
- View mapping process result after execution.
- Delete record entries from the product and order sync list.
- Set default shipping template for exporting products.
Customers will get a zip folder and they have to extract the contents of this zip folder on their system. The extracted folder has an src folder, inside the src folder you have the app folder. You need to transfer this app folder into the Magento 2 root directory on the server as shown below in the snapshot.
After the successful installation, you have to run the below commands in the Magento 2 root directory.
For translating the module language, please go to app>code>Webkul>MpEtsyMagentoConnect>i18n and edit the en_US.csv file. Now, translate the words on the right and upload the modified file to the same location. The filename of the translated file should be according to the language and region code like de_DE.csv.
How to Get the Consumer Key & Secret Key
Navigate to etsy.com/developers and click on the Register link as shown in the snapshot below.
Now on the pop-up, you can choose to register using your social account or enter your first name, email address, password, reenter the entered password, and lastly click the register button to register.
After registering in the previous step, click the Register as a Developer menu link. Here, you will have to verify the email address that you entered while registering and enable the Two-Factor authentication before creating the API key.
Enabling Two-factor Authentication:
Step 1: Click the Two-Factor Authentication link as shown below in the snapshot.
Step 2: This brings up the Security Settings section. Here, click the Enable button to enable two-factor authentication.
Step 3: Now, enter your mobile phone number with the correct country code and select your Confirmation type as – SMS/Text Message or Phone Call as per your feasibility and click Confirm Phone Number button.
Step 4: This brings up a popup to enter the two-factor code, enter the code and click the Confirm button.
You will also be able to backup codes(to sign in) that can be used to login in case you don’t have the mobile phone along.
After verifying the email address and setting up the Two-Factor Authentication now you can go back to the Register as Developer section. Here, enter all the related information on the page to create the app. Now, click the Read Terms and Create App button.
This brings a popup to accept the API agreement. Here check the agree to the terms and conditions checkbox and click the Create App button.
lastly, you need to have a Shop name(required for module configuration). To create one go to the Shop Settings menu link and create one. Here, you can see the shop name as WebkulShop.
After the successful installation of the extension, the admin will have the Etsy Account Manager menu option to manage the various Etsy accounts as shown below in the snapshot.
Tapping the Etsy Account Manager will bring this section that displays all the Etsy Seller Accounts that have been added to the store. Here, the admin can add/edit and delete the Etsy accounts as required.
To add a new Etsy seller account, tap the Add Etsy Seller Account button at the top right-hand side. This brings up a section to add the Etsy account information as shown below.
Here, the admin will enter the –
- Etsy Shop Name which should be same as your Etsy account.
- Select the default Attribute Set.
- Select the seller for whom you are adding the Etsy Account Information.
- Enter the OAuth Consumer Key.
- Enter the OAuth Consumer Secret.
- After entering the details click the Save Etsy Account button to save the credentials.
Now, this brings the same section to complete the rest of the settings that are to be completed after authenticating the account.
Now, the admin will Click the Authenticate button. After that, a pop-up appears click Allow Access to proceed further.
This grants access to the application and now you can see the authenticate is visible as authenticated.
Now, the admin will select –
- The default shipping template.
- The option to export the products to Etsy as Draft or Active product.
- Who made it?
- What it is?
- When it was made?
Click the Save Etsy Account at the top right-hand corner to save the Etsy account.
Under the General settings we have 2 more configuration settings –
- Default Settings for Import Etsy Products
Default store view for order import – Select the default store view for order sync.
Etsy Imported Order Status – Set default status for orders imported from Etsy store. The selected order status here will become the Etsy order status in Magento.
- Default Setting For Etsy Product
Default Website – The Selected website will be assigned to all Etsy products by default.
Product Revision on Etsy – If set Yes product will get revised on Etsy whenever you update mapped products with Etsy on Magento.
Magento Product Delete on Etsy Map Record Delete – If set Yes products will get removed from Magento whenever you delete mapped products record with Etsy on Magento.
Use Admin Categories – If you choose this option as Yes then admin mapped categories will be will be used.
After entering the correct Etsy seller account details, the admin will have to map the correct Etsy category with the Magento category. It allows adding the imported products from Etsy to the correct Magento category. The admin can not change the default category of imported products. As already there is a Category Sync option for the seller & admin. If the category is not mapped then no category gets assigned to the imported product.
To map the categories tap the Map Categories button, which brings up a section to map the Magento category with the Etsy category. Please note that you need to map the sub-category of Etsy with a sub-category of Magento. Now, click Save button to save the mapping.
The admin will be able to remap the existing mapped categories but only One(Magento) to N(Etsy) mapping is available.
Under this section, the admin will be able to import products from Etsy by selecting the status for import. After selecting the Etsy product status for import, click the Import Products From Etsy button. As the products at Etsy are simple products, they will get imported to your store as simple product without any custom options.
A pop-up appears with the total number of products to be imported. Here, click Ok button to import the products from Etsy.
After the product gets imported these details get imported along — Product name, Product images, SKU, Description, Price, Quantity, product variations for config product, Who made it?, What is it?, When did you make it?
Under here, you will find the list of all the synced orders. To import the Orders from Etsy; first, click Import Order From Etsy button. Also note that – If the orders are fetched automatically via Cron and if order items do not exist in Magento, it will automatically be created from Etsy to Magento 2 store only.
Then a pop-up window will appear for selecting the order date range. Otherwise, tick the option Import Store All Orders for getting all Etsy orders. Click the Import button to import the orders.
After importing the orders from Etsy, they’ll be added to Magento 2 orders. You can directly click on the order to view the details of the respective order. The admin will not be able to manage the imported orders. It’s only for inventory management & order information purposes. Real-time inventory update is not possible but we have cron setup for this at every hour for order import for inventory management.
Export to Etsy:
After product export following product information gets exported – Product name, Product images, SKU, Description, Price, Quantity, product variations for config product, Who made it?, What is it?, When did you make it?
Edit Seller Account
To edit Etsy seller account tap the Edit link under the Action column. The brings up the section to alter the details like –
The sellers will get a new menu option within their account panel after the installation of this extension.
Hovering over the Etsy Connector menu option with the mouse brings the 6 sub-menu options:
Let’s go through all the sub-menu options available to the seller –
Here, the vendors will be able to add their Etsy Seller account details. To do so, click the Etsy Account sub-menu option
Here, we have 4 settings –
1. Default Values For Product listing Which Exported to Etsy(select respective options) –
- Select who made it?
- Select what it is?
- Select when it made?
2. Default Settings for Import Etsy Orders –
- Select the default Store View for order Import.
- Select the Etsy imported Order status.
3. Default Setting for Etsy Product –
- Select the default attribute set.
- Select the default website.
- Select Yes or No for product revision on Etsy.
- Select Yes or No for product delete on Etsy Map Record delete.
4. Default setting for Category mapping –
- Select Yes to make use of the admin mapped categories else select No to make use of your own mapped categories.
- Clicking the Link Click here to view administrator mapped categories shows the mapped categories by the admin as shown below in the snapshot.
Here, the sellers can map the categories of Etsy with their Magento store categories so that the products can be synced between Magento and Etsy. If the setting under General settings, the option Use Admin Categories is selected as Yes, then the seller will only be able to make use of the admin mapped categories as shown below in the snapshot.
If the setting under General settings, the option Use Admin Categories is selected as No then the sellers will be able to map the categories on their own. Here the admin can search the the categories using the category name and clicking the submit button. To map categories, click the Map Categories button as shown below in the snapshot.
Tapping the Map Categories button brings up the pop-up. To map the Magento category with the Etsy category. Please note that you need to map the sub-category of Etsy with a sub-category of Magento. Now, click Save button to save the mapping.
After a successful mapping you can see a confirmation box for the same. Click Ok on it to return.
Now, you can see the mapped categories under this particular section.
The sellers will be able to remap the existing mapped categories but only One(Magento) to N(Etsy) mapping is available.
Here, the seller will be able to check the products that have been imported from Etsy to Magento. The seller will be able to check the details like – Product Name, Etsy Listing Id, Magento Category, Sync Date. The seller can also edit or delete the products as required. The seller will also be able to search the products using the product name and then tapping the Submit button.
To import products, first select the status of Etsy products which you want to import and then click the Import Products button. This brings up a pop-up to show the number of products that will be imported.
After importing the products, now click on the Run Profiler button to create the products within Magento. After the product creation you will see the success message as well.
To import order from Etsy you need to navigate to Etsy Connect>Etsy Account. Here, you can find all the orders imported from Etsy to Magento Store. You can find the details related to the orders like – Magento Order Id, Etsy Order Id, Sync Date, and the View option to view the order.
Clicking the View Button brings up the details of the respective order as shown below in the snapshot.
Import Orders – Click on the Import Orders button, this brings up a pop-up to choose the date range or the option to import all the orders. After making the required selection, the seller will click on the Import button.
Now to create the orders, click the Create Imported Orders button which will start creating the orders in magento as shown below in the snapshot.
The sellers will not be able to manage the imported orders. It’s only for inventory management & order information purposes.
Under this section, the seller will be able to exported products from Magento to Etsy store. Here, the seller can see all of his own products and can start exporting them to Etsy.
To export the products, select the products and tap the Export Products To Etsy button. It starts the export of the products from Magento to Etsy as shown below in the snapshot.
Current Product Version - 2.0.0
Supported Framework Version - 2.0.x, 2.1.x, 2.2.x