Last updated 28/06/2019
The integration with Etsy can be configured to suit your business from the Settings page.
To locate the 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.
Use this date filter to define which products to download - products created before the date set here will not be downloaded.
Ticking the Stock checkbox will enable stock to be updated from Cin7 to Etsy.
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.
Ticking the Orders checkbox will enable orders to be downloaded from Etsy to Cin7.
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.
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.
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.
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.
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.
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:
Order Price Column
When downloading orders you can choose from the following the Price Column assigned to the order:
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.