Zulily Account Integration

Overview

Zulily is an online retail company that specializes in daily deals and flash sales for a wide range of products. Instead of offering a permanent inventory, Zulily works with brands and vendors to source products at discounted prices.

Zulily Account Integration allows you to sell on their platform through Sellercloud. This integration works through EDI documents, transmitting information between the two services. The following plugins are currently available in Sellercloud:

    • Order Import – Imports orders from Zulil to Sellercloud in EDI 850 format.
    • Tracking Export – Exports tracking information to Zulily in EDI 856 format.
    • Invoice Export – Exports invoices to Zulily in EDI 810 format.
    • Inventory Export – Exports inventory to Zulily in EDI 846 format.

You can contact Sellercloud Support to request additional customizations or other plugins for this integration.

To have a dedicated representative complete the testing for your account and ensure that the setup is configured correctly, we recommend Premium Support.

Prerequisites

Before you can integrate Zulily with Sellercloud, complete the following requirements.

You must contact Zulily for your FTP details: Server Name, Username, and Password. You will need them when setting up the scheduled tasks to automate the plugins.

We recommend creating a Company where you will set up the Custom Company Settings and automate the plugins with Scheduled Tasks.

Custom Company Settings

Create the following Custom Company Settings in your Default Company:

    • STControlNumber
    • GSControlNumber
    • ISAControlNumber 
    • Zulily_CustomerISAID – Usually a phone number that is not being used for any other integration.
    • Zulily_ISAID – Retrieved from Zulily. Usually [check clients, the Channel ISA ID is the same for all].
    • Zulily_CustomerQualifier – usually ZZ
    • Zulily_Qualifier – usually ZZ
    • ZulilyVendorName – Retrieved from Zulily.
    • ZulilyVendorId – Retrieved from Zulily.
    • Zulily_ImportOrders_AsChannel_ID (optional) – For Fulfillment Center workflow.
    • Zulily_ImportOrderAsUnpaid (optional) – For Fulfillment Center workflow.
    • Zulily_ShippingRequiresThirdPartyBilling (optional) – For Fulfillment Center workflow.
    • Zulily_MarkOrdersAsRush (optional) – If the value is True, orders will be labeled as Rush Orders.
ISAControlNumber, GSControlNumber, and STControlNumber can all start at 1. The tracking and inventory exports will increment this number accordingly as jobs are processed. If the settings already exist and have values in them, do not edit them.

On the company created for the integration:

    • Zulily_DefaultFixedQty 
    • Zulily_FC_ISAID (optional) – populate with the ISA ID that fulfillment center orders are sent to.
    • RemoveOneAtEndOfHLoop (optional) – Defaults to False. If set to True, it removes shipment reference from the EDI file (eliminates the 1s at the end of H Loops, or Hierarchical Loops). 

Sellercloud Support

You must contact Sellercloud Support and request:

  1. To install the Zulily Plugins on your server.
  2. The following Custom Product and Order Columns:

Custom Product Columns

    • Zulily_Enabled – (optional, not part of the plugin) Used to enable only specific products for Zulily. Set to True for any products you want to send with the Inventory Export plugin.
    • ZULILY_SAFETYQTY – Sets Safety Quantity for products on Zulily.
    • ZULILY_MAXQTY – Sets the maximum inventory amount sent to Zulily for a specific SKU.
    • ZULILY_SKU – a product’s SKU on Zulily.
    • ZULILY_UPC – allows you to set a channel-specific UPC for Zulily. 

Custom Order Columns

    • ZULILY_STORENUMBER
    • IsZulilyFCOrder (optional) – Applicable only for Fulfillment Center workflow.

Order Import

You can import order data from Zulily to Sellercloud in EDI 850 format. 

Currently, there are 2 Order plugins, based on the order type:

    • Zulily EDI 850 Order import – used for Dropship Orders. This integration sets the carrier to UPS and allows the usage of UPS Ground as a shipping method. This plugin also supports Fulfillment Center (FC) Orders.
    • Zulily Order Import FC EDI 850 used for Fulfillment Center Orders only.

Automate Order Import

To create a Scheduled Task that regularly imports orders:

  1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
  2. Click the green + icon: Create New Scheduled Task.
  3. Complete as follows:
    1. Click Task Type and select Import Orders.
    2. Set the Task Name.
    3. Select the Company.
    4. Select the Start Time.
    5. Click CREATE.
  4. The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
  5. Click the Edit button on the top right.
  6. In the Details section:
    1. Click the Create Orders For Company menu and select the company you designated for this integration.
    2. Click the Plugin menu and select DBA Zulily Order Import 850. If another task is required for Fulfillment Center Orders, choose Zulily Order Import FC EDI 850.
  7. In the Import Options section, set Import From to FTP and fill out the FTP Server credentials 
    1. Check Use Secure FTP.
    2. Check Use Passive.
  8. In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  9. In the General section, click the Enable button.
  10. Click Save on the top right.


Tracking Export

This plugin exports tracking from Sellercloud to Zulily following the 856 EDI format. 

Currently, there are 2 Tracking export plugins, based on the order type:

    • DBA Zulily Tracking Export EDI 856 – used for Dropship Orders. 
    • DBA Zulily FC Tracking Export EDI 856 – used for Fulfillment Center Orders.
If Tracking exports are required for both order types, 2 Scheduled Tasks should be created.

Dropship Orders

In order for the DBA Zulily Tracking Export EDI 856 plugin to function, create a Saved Search for orders filtered by:

  • Company – The company you created for the integration.
  • Order Status – InProcess Or Completed
  • Shipping Status – FullyShipped
  • Payment Status – Charged
  • Tracking Uploaded – No
  • Order Ack (Accept) – Yes

Fulfillment Center Orders

Additional configuration is required to manage Fulfillment Center Orders:

  • Add custom setting Zulily_FC_ISAID and populate with the ISA ID that fulfillment center orders are sent to.
  • Set up separate tasks and searches for the following:
    • IsZulilyFCOrder should be set to True.
    • The plugin exports only one order at a time, even if multiple orders are searched.
    • The sender ISA ID used will be Zulily_FC_ISAID.

Before you move on, create a Saved Search for orders filtered by:

  • Company – The company you created for the integration.
  • Order Status – InProcess Or Completed
  • Shipping Status – FullyShipped
  • Payment Status – Charged
  • Tracking Uploaded – No
  • Order Ack (Accept) – Yes
  • IsZulilyFCOrder – Yes

Automate Tracking Export

To create a Scheduled Task that regularly exports order tracking:

  1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
  2. Click the green + icon: Create New Scheduled Task.
  3. Complete as follows:
    1. Click Task Type and select Export Orders.
    2. Set the Task Name.
    3. Select the Company.
    4. Select the Start Time.
    5. Click CREATE.
  4. The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
  5. Click the Edit button on the top right.
  6. In the Details section:
    1. Click the User ID menu and select your ID.
    2. Click the Saved Search menu and select the saved search you created earlier.
    3. Click the Export Via menu and select DBA Zulily Tracking Export EDI 856. If another task is required for Fulfillment Center Orders, choose DBA Zulily FC Tracking Export EDI 856.
    4. Check This Is Tracking Export.
  7. In the Export Options section, set Export To to FTP and fill out the FTP Server credentials 
    1. Check Use Secure FTP.
    2. Check Use Passive.
  8. In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  9. In the General section, click the Enable toggle button.
  10. Click Save on the top right.


Invoice Export

This plugin exports invoices from Sellercloud to Zulily in EDI 810 format.

Before you move on, create a Saved Search for orders filtered by:

    • Company – The company you created for the integration.
    • Shipping Status – Fully Shipped
    • Order Status – InProcess Or Completed
    • Invoice Uploaded – No
    • Tracking Uploaded – Yes

Automate Invoice Export

To create a Scheduled Task that regularly exports invoices:

  1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
  2. Click the green + icon: Create New Scheduled Task.
  3. Complete as follows:
    1. Click Task Type and select Export Orders.
    2. Set the Task Name.
    3. Select the Company.
    4. Select the Start Time.
    5. Click CREATE.
  4. The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
  5. Click the Edit button on the top right.
  6. In the Details section:
    1. Click the User ID menu and select your ID.
    2. Click the Saved Search menu and select the saved search you created earlier.
    3. Click the Export Via menu and select DBA Zulily Invoice Export EDI 810.
    4. Check This Is Invoice Export.
  7. In the Export Options section, set Export To to FTP and fill out the FTP Server credentials 
    1. Check Use Secure FTP.
    2. Check Use Passive.
  8. In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  9. In the General section, click the Enable toggle button.
  10. Click Save on the top right.

Fulfillment Center and Dropship orders have the same invoice type.

Inventory Export

This plugin exports inventory from Sellercloud to Zulily in EDI 846 format. 

Optionally, you can enable only specific products for Zulily by setting their Zulily_Enabled Custom Column for Products to True:

    • For one product at a time: go to the Product Details Page > click Toolbox and select Custom Columns > click Edit, update the Zulily_Enabled column, and Save.
    • For multiple products in bulk: follow the steps to Bulk Update Products and use the Zulily_Enabled column – set it to True for all products you want to enable.

Unlike core integrations, plugin integrations don’t require products to be in the company with the scheduled tasks. The export will include the products you select with your Saved Search.

Before you move on, create a Saved View for products filtered by Zulily_Enabled – True. Optionally, you can add more filters to the search.

Automate Inventory Export

To create a Scheduled Task that regularly exports inventory:

  1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
  2. Click the green + icon: Create New Scheduled Task.
  3. Complete as follows:
    1. Click Task Type and select Export Products.
    2. Set the Task Name.
    3. Select the Company.
    4. Select the Start Time.
    5. Click CREATE.
  4. The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
  5. Click the Edit button on the top right.
  6. In the Details section:
    1. Click the User ID menu and select your ID.
    2. Click the Saved Search menu and select the saved search you created earlier.
    3. Click the Export Via menu and select DBA Zulily Inventory Export EDI 846.
  7. In the Export Options section, set Export To to FTP and fill out the FTP Server credentials 
    1. Check Use Secure FTP.
    2. Check Use Passive.
  8. In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  9. In the General section, click the Enable toggle button.
  10. Click Save on the top right.


 

Was this article helpful?

Need Support?
Can't find the answer you're looking for?
Contact Support