Searching...

Quoizel Account Integration

Overview

Quoizel is a decorative lighting company offering a range of indoor and outdoor lighting solutions, known for blending classic and contemporary designs. Founded in 1930, they focus on craftsmanship and offering elegant, timeless lighting pieces.

Integrating Quoizel allows you to synchronize their platform with Sellercloud. This integration works through EDI documents, transmitting data between the two services via plugins and Scheduled Tasks.

If necessary, you can open a ticket with Sellercloud Support to request additional customizations or other plugins for this integration. Any such modifications will be billable.

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 Quoizel into Sellercloud, complete the following requirements.

We recommend creating a Company where you will set up the Custom Company Settings and automate the plugins with Scheduled Tasks.
You must Create a Vendor named Quoizel under the company designated for the integration and configure your Vendor SKUs.

Sellercloud Support

Open a ticket with Sellercloud Support and request an FTP for the integration, as well as the following plugins be installed on your server:

  • Quoizel EDI850 Order Export – Exports orders from Sellercloud to Quoizel in EDI 850 format.
  • Quoizel EDI855 Order Ack Import – Imports order acknowledgment from Quoizel in EDI 855 format.
  • Quoizel EDI 856 Order Tracking Import – Imports tracking information from Quoizel in EDI 856 format.
  • Quoizel EDI810 Order Invoice Import – Imports invoices from Quoizel in EDI 810 format.
  • Quoizel EDI846 InventoryImport – Imports inventory from Quoizel in EDI 846 format.

Custom Company Settings

Create the following Custom Company Settings on the company designated for the integration:

  • STControlNumber – Set to 1.
  • GSControlNumber – Set to 1.
  • ISAControlNumber – Set to 1.
  • Quoizel_Vendor_ISAID – Quoizel’s unique identifier for the document transmission – contact them for the value of this setting.
  • Quoizel_ISAID – Enter a unique phone number that is not used for any other integration.
  • Quoizel_IDRecieverQualifier – Set to 01.
  • Quoizel_IDInterchangeQualifier – Set to ZZ.
  • (Optional) Quoizel_EDI856_VendorsUsing_ShipmentOrderPackageItem – Enter a comma-delimited list of Vendor IDs. The Tracking Import plugin uses this setting to determine the structure for parsing EDI files. 
    • If the vendor for the order is present in the comma-delimited list, the structure is as follows: Shipment > Order > Package > Item.
    • If the setting is missing, not configured, or the vendor is not listed, the structure is as follows: Shipment > Order > Item.
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.

Custom Order Columns

Create this Custom Order Column:

  • EDI850_VendorID – The ID of the Vendor for processing orders. If this column is empty, it defaults to Quoizel. 

Order Export

This plugin exports order data from Sellercloud to Quoizel in EDI 850 format and sets the order’s Dropship Status to Requested. The Quoizel Vendor SKU and Price are exported as the product identifiers.

You must have a vendor named Quoizel associated with the company where you create the Scheduled Task. Otherwise, the plugin will not work.

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

  • Company – The company designated for the integration
  • Order Status – InProcess Or Completed
  • Exported – Not Exported
  • Payment Status – Charged
  • Shipping Status – Unshipped

Automate Order Export

To create a Scheduled Task that exports 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 Export Orders.
    2. Set the Task Name.
    3. Select the Company.
    4. Select the Start Time.
    5. Click CREATE.
  4. On the Scheduled Task page, click the Edit button at the top right corner.
  5. In the Details panel:
    1. Click the User ID menu and select your email.
    2. Click the Saved Search menu and select the saved search you created earlier.
    3. Click the Export Via menu and select Quoizel EDI850 Order Export.
    4. Check Mark Orders As Exported.
  6. In the Export Options panel, set Export To to FTP and fill out the FTP fields.
  7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  8. In the General panel, click the Enable button.
  9. Click Save.

Order Acknowledgment

This plugin imports order acknowledgment from Quoizel following the 855 EDI format and sets the order’s Dropship Status to Acknowledged or Cancelled. It also saves the acknowledgment code for each order item into the Item Notes.

Automate Order Acknowledgment

To create a Scheduled Task that imports order acknowledgment:

  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. On the Scheduled Task page, click the Edit button at the top right corner.
  5. In the Details panel:
    1. Set Create Orders For Company to the integration company.
    2. Set the Plugin to Quoizel EDI855 Order Ack Import.
  6. In the Import Options panel, set Import From to FTP and fill out the FTP fields.
  7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  8. In the General panel, click the Enable toggle button.
  9. Click Save.

Tracking Import

This plugin imports tracking from Quoizel to Sellercloud following the 856 EDI format, updating Tracking Numbers, the Shipping Service and Carrier, the Ship Date, and the Order Items’ Qty Shipped.

Whenever the plugin imports two or more unique Tracking Numbers into a single order, it creates multiple packages for that order. It also updates the Shipped Quantity of the order items and sets the order’s Shipping Service and Carrier based on the imported information.

For the plugin to import tracking information successfully, the Vendor’s (Seller’s) Item # in the file must match the Vendor SKU specified in the Vendor Prices panel for the item associated with the order. Each order’s vendor is determined by the Custom Order Column EDI850_VendorID. If that column is empty, it defaults to Quoizel.

If either vendor is present in the comma-delimited list in the Custom Company Setting Quoizel_EDI856_VendorsUsing_ShipmentOrderPackageItem, the structure Shipment > Order > Package > Item will be used when parsing the EDI file. Otherwise, the Shipment > Order > Item structure will be used.

Automate Tracking Import

To create a Scheduled Task that imports 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 Import Orders.
    2. Set the Task Name.
    3. Select the Company.
    4. Select the Start Time.
    5. Click CREATE.
  4. On the Scheduled Task page, click the Edit button at the top right corner.
  5. In the Details panel:
    1. Set Create Orders For Company to the integration company.
    2. Set the Plugin to Quoizel EDI 856 Order Tracking Import.
  6. In the Import Options panel, set Import From to FTP and fill out the FTP fields.
  7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  8. In the General panel, click the Enable toggle button.
  9. Click Save.

Invoice Import

This plugin imports EDI 810 files and creates PDF invoices in Sellercloud. It also updates the Unit Price of the items on the PO based on the prices in the 810 EDI files. 

If an order ID in the imported EDI file does not match any order ID in Sellercloud, or if the order in Sellercloud doesn’t have a PO linked to it, the plugin skips the order.

The EDI file and the PDF invoice are saved in the transaction documents, accessible by going to the Order Details Page, clicking Actions, and selecting View Action Documents.

To check the PO invoice, ensure the Client Setting Enable Multiple invoices for purchase orders is enabled, then go to the PO Details Page, click Actions, and select Manage Invoices. 

Automate Invoice Import

To create a Scheduled Task that imports 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 Import Orders.
    2. Set the Task Name.
    3. Select the Company.
    4. Select the Start Time.
    5. Click CREATE.
  4. On the Scheduled Task page, click the Edit button at the top right corner.
  5. In the Details panel:
    1. Set Create Orders For Company to the integration company.
    2. Set the Plugin to Quoizel EDI810 Order Invoice Import.
  6. In the Import Options panel, set Import From to FTP and fill out the FTP fields.
  7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  8. In the General panel, click the Enable toggle button.
  9. Click Save.

Inventory Import

This plugin imports inventory from Quoizel to Sellercloud in EDI 846 format. This plugin does not create products.

The plugin imports inventory into the Default Warehouse for DropShip of the specified Vendor ID in the Scheduled Task’s Notes field. The products are matched by Vendor SKU. 

If the vendor specified in the Notes field of the task does not exist in the same company where the task is configured, the plugin will not execute. The plugin will also zero out the inventory of any products that are not included in the EDI file but have this vendor set as the Default Vendor.

Automate Inventory Import

To create a Scheduled Task that imports 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 Import Products.
    2. Set the Task Name.
    3. Select the Company.
    4. Select the Start Time.
    5. Click CREATE.
  4. On the Scheduled Task page, click the Edit button at the top right corner.
  5. In the Note field of the General panel, enter a Vendor ID. The products in the vendor’s Default Warehouse for DropShip will receive inventory updates.
  6. In the Details panel:
    1. Set Create Orders For Company to the integration company.
    2. Set the Plugin to Quoizel EDI846 InventoryImport.
  7. In the Import Options panel, set Import From to FTP and fill out the FTP fields.
  8. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  9. In the General panel, click the Enable toggle button.
  10. Click Save.

Was this article helpful?

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