• Contents

Etsy Settings

Last updated 28/06/2019

This article explains how to configure your Etsy integration with Cin7's extensive settings.

Finding the Settings


The integration with Etsy can be configured to suit your business from the Settings page.

To locate the settings:

  1. Whilst logged in as an administrator, from the left navigation select Integrations and then click on your Etsy module.
  2. From the top right of the page, click Settings.

Product Settings


Ticking the Products checkbox will enable Products to be downloaded from Etsy.

Etsy products are mapped to Cin7 products using the Variant SKU. If no matching SKU can be found in Cin7 then the product will be imported - see Downloading Etsy Products to Cin7.

Last Updated

Use this date filter to define which products to download - products created before the date set here will not be downloaded.

Stock Settings


Ticking the Stock checkbox will enable stock to be updated from Cin7 to Etsy.

Last Updated

When updating stock, only stock that has changed after this date will be updated. Simply leave this field alone at all times unless under special circumstances.

Auto Sync Stock

Ticking this box will sync stock levels when ever you visit the admin screen of a module and whenever you download an order. We recommend only ticking this box if you are confident your stock levels are accurate.

Get Stock Levels From

When updating stock levels, you can choose to only update stock levels from a particular branch.

Stock Levels To Update To Etsy

When updating stock levels, you can choose how to calculate the stock number to update.

Stock available Stock on hand minus open orders - i.e. stock you can dispatch without disappointing other customers.
Stock on Hand The stock you have physically available, regardless of outstanding orders.
SOH Less Open Orders within 7 days of ETD You may choose this if you can replenish stock within a week. The ETD must be entered for all outstanding orders for this to be accurate.
SOH Less Open Orders within 30 days of ETD You may choose this if you can replenish stock within a month. The ETD must be entered for all outstanding orders for this to be accurate.


Subtract Buffer Stock From Stock Levels

Add in buffer stock levels to ensure you never oversell.

Orders Settings


Ticking the Orders checkbox will enable orders to be downloaded from Etsy to Cin7.

What Orders to Download

Last Updated

When downloading orders, only orders that have been updated after this date and time will be downloaded. After orders are downloaded successfully, these fields will be changed automatically to the current date and time.

Auto Update Orders Status

Check this option if you would like orders status in Etsy to be updated automatically when a review page of a transaction is visited.

Note that if you have any auto-responses in Etsy upon the change of status of orders, these may be triggered when updating orders.

Auto Download Orders

Turn on the automatic download schedule:

We will check for orders at first every 5 minutes. If no orders are pulled down, we will wait a little longer - 10 minutes - before checking again. If nothing is found, we’ll wait 20 minutes before checking again and so on. At most, we'll check every 2 hours. If an order is downloaded, we’ll wait 5 minutes all over again.

Choose from the drop down when the schedule should start each day.

Download Order when Etsy Order Status is

You may only want to download orders at a certain stage in Etsy e.g. if you use Etsy to pick and pack your orders, you opt to download only orders that have been closed.

Custom statuses can be added by clicking Add Custom Status below.

Set Default Stage to

Choose the Cin7 stage orders should be created under. If set to blank no stage will be applied. This is useful if you want to filter your Etsy orders by stage.

Inventory

Auto Dispatch Orders

Cin7 can attempt to dispatch orders automatically upon download - this option is useful if you prefer to dispatch from the Etsy module, and simply download orders for stock purposes only. This is not possible for those orders that have batch or serial numbers, or in cases when there is not enough stock.

Automatically Load BOMs for Kits

If you have a bill of materials (or BOM) assigned to your finished products, you can choose for the BOM to be expanded automatically when you download orders. This requires the finished product to have its Order Type set to 'Kit' in the product details.

Branches

Set Default Branch to

Set the branch for all new Etsy orders to be downloaded into. The branch can be changed manually in a Sales Order before it is dispatched.

Route Branch by Country and Stock

Branches can be routed based on country, state, shipping options, and stock. See more information in the Branch Based Routing help file.

Customers

How To Create Or Assign A Customer From An Order

This option controls how customer records should be handled when orders are downloaded. The options allow you to match to existing contacts based on email address or ID.

You can also download all orders to one predefined contact, regardless of the customer's details in the original order. This may be useful if you do not wish your CRM to be filled by online customers.

If Customer ID or email exists update customer or else insert new customer
If Customer ID or email exists do not update or else insert new customer
If Customer ID exists do not update else assign to selected customer
If email exists update customer else insert new customer
If email exists update customer else assign to selected customer
Assign to selected customer

Assign To CRM Customer Group (Optional)

This option will assign new customer contacts in the CRM to a particular reporting group. Options are populated by the Customer Groups, which can be added in the Settings page.

Customer Payment Terms

When new customers are created, you can automatically assign the customer a specific Payment Term by selecting one from the dropdown list here.

Customer Price Column

When new customers are created, you can automatically assign the customer a specific price column by selecting one from the dropdown list here.

Customer GL Account (Optional)

Choose an Alternative General Ledger account to apply to customers that are imported into Cin7 through Etsy orders. This will apply the Alternative GL Account at the customer level.

Accounts

Invoice Options

Each order is downloaded to Cin7 individually. However, when importing orders to your accounting software, you may not wish to import each order. This option allows you to batch invoices for accounting purposes.

Allow batch invoices This will leave the invoice date blank and an invoice number will not be generated until you fill it in manually or process a batch of payments.
Import Invoices Individually This will add an invoice date and generate an invoice number for all new Etsy orders.

Order Payment Terms

When downloading orders you can choose from the following the payment terms assigned to the order:

  • Use the contact's assigned payment terms (this assumes the contact already exists).
  • Use the contacts assigned payment terms, but if the contact doesn't exist, use a specified value.
  • Always use a specified value.

Order Price Column

When downloading orders you can choose from the following the Price Column assigned to the order:

  • Use the contact's assigned Price Column (this assumes the contact already exists).
  • Use the contacts assigned Price Column, but if the contact doesn't exist, use a specified value.
  • Always use a specified value.

Order GL Account (Optional)

Choose an Alternative General Ledger account to apply to Etsy orders. This will apply the Alternative GL Account at the order level.