Sell on Zulily

Selling on Zulily

Zulily is a great place to introduce your products to millions of new customers. As a popular daily-deal site used by moms everywhere, you can market deals on products for the whole family including clothing, shoes, home décor, toys, gifts and more.

Zulily will review your products and negotiate pricing. Then, you’ll provide Zulily with a product file containing descriptions, images and the quantity you are allocating for the event.

Learn more about becoming a vendor for Zulily here.


Integrating with Zulily

Sellercloud integrates with Zulily through plugins. If you have integrated a website with Sellercloud (other than a Magento website), create a separate company for Zulily. This is because, with a particular Zulily plugin, orders will import as Website orders, so you will want to separate them from your regular Website. However, orders can be imported as other than Website using the custom column Zulily_ImportOrders_AsChannel_ID. This setting is only available when using the Order Import Plugin: DBA Zulily Order Import.

You do not need to create shadows, as inventory is not updated from Sellercloud with inventory feeds.

Integration workflow

  1. Seller: Create a company for Zulily along with required custom company settings.
  2. Sellercloud Support: Create the required custom order and product columns.
  3. Sellercloud Support: Install the plugins on the server.
  4. Seller: Create saved searches and scheduled tasks for the installed plugins.

Using custom columns

There are various custom columns that can be used when integrating with Zulily. Each is specific to one of the plugins.

COLUMN DESCRIPTION
Product columns Zulily_SafetyQty (optional) Sets safety quantity on a product level
Zulily_MaxQty (optional) Will set the maximum inventory amount sent to the channel for a specific SKU
Order columns RemoveOneAtEndOfHLoop (optional)
  • Set to True This will remove the 1s at the end of H Loops, or Hierarchical Loops. The 1 is the reference of a shipment within the EDI file. Setting to True will remove the shipment reference 
  • It will default to False
Company columns (Default Company) Zulily_MarkOrdersAsRush (optional) When set to True, orders are marked as Rush
Zulily_ImportOrders_AsChannel_ID (optional) Entering a Channel ID will import orders with the specified Channel ID
Zulily_ImportOrderAsUnpaid (optional) When set to True, orders are imported as Unpaid

Installing the plugins

These plugins require the following custom company settings:

  • Zulily_CustomerISAID— Client’s phone number
  • Zulily_ISAID— Retrieved from Zulily
  • Zulily_CustomerQualifier— ZZ
  • Zulily_Qualifier— ZZ
  • ISAControlNumber*
  • STControlNumber*
  • GSControlNumber*
  • ZulilyVendorName— Retrieved from Zulily
  • ZulilyVendorId— Retrieved from Zulily

* ISAControlNumber, GSControlNumber, and STControlNumber can all start at 1. The tracking and inventory exports will increment this number accordingly. 

Sellercloud Support will install the following Zulily plugins onto the server.

PLUGIN DESCRIPTION
Zulily Tracking Export EDI 856 This will send tracking information to Zulily
Zulily Inventory Export EDI 846 This will export inventory to Zulily
Zulily Invoice Export EDI 810 This will create an invoice on Zulily
Zulily Order Import 850 This will set the carrier to UPS and allow for use of UPS Ground as a shipping method

Creating saved searches and scheduled tasks

Each of the plugins requires the setup of a scheduled task, which let you configure certain actions for automatic recurrence at specific intervals. Each of the scheduled tasks will use saved searches.

PLUGIN SAVED SEARCH/ SCHEDULED TASKS
Zulily Invoice Export EDI 810 Zulily 810 Invoice Export

  1. Create an Orders Saved Search.
  2. Filter as follows:
    1. Company = Your channel company
    2. Status = InProcess or Completed
    3. Shipping Status = Fully Shipped
    4. Tracking Uploaded = Uploaded
    5. Invoice Sent = Not Sent
Zulily Inventory Export EDI 846 Zulily 846 Inventory Export

  1. Create an Inventory Saved Search.
  2. Choose any filters you want to choose which products to send.
Zulily Order Import 850 Zulily 850 Order Import

  1. Create an Orders Saved Search.
  2. Filter as follows:
    1. Company = Your channel company
    2. Status = InProcess or Completed
    3. Shipping Status = Fully Shipped
    4. Tracking Uploaded = Not Uploaded
Zulily Tracking Export EDI 856 Zulily 856 Tracking Export

  1. Create an Orders Saved Search.
  2. Filter as follows:
    1. Company = Your channel company
    2. Status = InProcess or Completed
    3. Shipping Status = Fully Shipped
    4. Tracking Uploaded = Not Uploaded

Was this article helpful?

Related Articles