QVC Account Integration

Overview

QVC, which stands for “Quality, Value, and Convenience,” is a well-known American TV network and online retailer. QVC’s online shop offers a variety of product categories, including fashion, electronics, home and kitchen items, health and fitness products, and much more. What sets QVC apart is its live and on-demand video presentations, providing an interactive shopping experience with product demonstrations and expert advice.

Integrating QVC into Sellercloud allows you to update the inventory levels of your QVC listings, manage your QVC orders, and more. This integration works through EDI documents, which transmit information between the two platforms. The document exchange goes through CommerceHub – a third-party platform that provides the Secure File Transfer Protocol (SFTP) server and credentials.

The following plugins are currently available in Sellercloud:

• Order Import – Imports orders from QVC to Sellercloud in EDI 850 format and sends order acknowledgment to QVC in EDI 997 format.
• Tracking Export  – Exports tracking information to QVC in EDI 856 format.
• PDF Invoice – Creates printable PDF packing slips for QVC orders.
• Inventory Export – Exports inventory to QVC in EDI 846 format.

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

---

Prerequisites

Before integrating your Sellercloud account with QVC, you must have the following accounts:

• QVC Vendor Account – Contact QVC  to become an approved vendor. You may need to submit a product proposal.
• CommerceHub Account – To integrate QVC, you must have an account with CommerceHub. You will be assigned a Partner Setup Specialist working with Sellercloud Support to integrate your account and get you live on QVC. 

Next, complete the following requirements:

CommerceHub Support

Contact CommerceHub for your SFTP details: Server Name, Username, and Password. You will need them when setting up the scheduled tasks to automate the plugins. Additionally, ask for their ISA ID – you will need it when populating the Custom Company Settings.

Custom Company Settings

Create the following Custom Company Settings.

On your default company:

• STControlNumber
• GSControlNumber
• ISAControlNumber

On the company created for the integration:

• QVC_ISAID – CommerceHub’s unique identifier, used to exchange EDI documents. Contact them for the value.
• QVC_Vendor_ISAID – Enter a unique phone number you don’t currently use for another integration.
• QVC_IDReceiverQualifier – Set to 12.
• QVC_IDInterchangeQualifier – Set to ZZ.
• QVC_ShippingRequiresThirdPartyBilling (Optional) – Enter True for QVC orders’ ShippingRequiresThirdParty setting to be set to True, indicating that Third-Party Billing is required.
• QVC_SkipImportingPayment (Optional) – Defaults to False. If you set it to True, the Order Import plugin will not import any payments.
• QVC_LockShippingMethod (Optional) – Defaults to False. If you set it to True, the Order Import plugin will lock the shipping method.
• QVC_DontPrintReturnPage (Optional) – Defaults to False. If you set it to True, the Order PDF Invoice plugin will exclude the return page.
• ExportMultipleWarehousesOnQVC846 – Enter True to export inventory per warehouse instead of sending the total inventory.
• QVC_WarehouseCodeMapping – Use this setting to map your Sellercloud warehouses to specific warehouse codes and set safety quantities. Follow this format: {WarehouseID1}/{WarehouseID2},{QVCWarehouseCode},{SafetyQty}. See the example below this settings list.
• QVC_RetailerName (Optional) – Added to replace the hardcoded REF02.
• QVC_SafetyQty (Optional) – A Safety Quantity for products on QVC. This only applies if you don’t enable the QVC_WarehouseCodeMapping setting. If you enable QVC_WarehouseCodeMapping, you must specify the Safety Quantity per warehouse there.

The following is an example of the format for the QVC_WarehouseCodeMapping setting:

• Warehouse ID in Sellercloud = 345, Warehouse Code = California, Safety Quantity = 0
• Warehouse ID in Sellercloud = 123, Warehouse Code = California, Safety Quantity = 0
• Warehouse ID in Sellercloud = 234, Warehouse Code = Florida, Safety Quantity = 1

For this scenario, the setting’s value would be: 123/345,California,0;234,Florida,1

Sellercloud Support

You must contact Sellercloud Support and request:

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

Custom Product Columns

• QVCENABLED – Optional column used to enable only specific products for QVC. Set to True for any products you want to send with the Inventory Export plugin.
• QVC_SKU – Corresponds to the QVC Merchant SKU. If this field is blank, the Inventory Export plugin will send the Sellercloud SKU.
• QVC_MERCHANT_SKU – Corresponds to the QVC Vendor SKU/Item Number. If this field is blank, the Inventory Export plugin will send the Sellercloud SKU.
• EXPECTED_AVAILABLE_DATE – The date when the product is expected to become available. If you don’t create this field or leave it blank, the default value sent to QVC will equal 1 month after the export.

Custom Order Columns

• QVC_VENDORNUMBER – To be created as a String.
• Qvc_LabelTrackingNumber – To be created as a String.
• Qvc_DeliveryReference – To be created as a String.
• Qvc_ReturnToPartnerSortCode – To be created as a String.   
• Qvc_ShippingLabelFee – To be created as a Decimal.
• QVC_CreditAmount – To be created as a Decimal.             
• QVC_MemberNumber – To be created as a String.
• QVC_PaymentMethod – To be created as a String.
• QVC_ShipFromAddress – To be created as nText.
• QVC_FirstProductInfo_PackingSlip

---

Order Import

This plugin imports order data from QVC to Sellercloud in EDI 850 format and then sends an acknowledgment to QVC in EDI 997 format.

Automate Order Import

To create a Scheduled Task that 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 Create Orders For Company and select the company designated for this integration.
   2. Click the Plugin menu and select QVC 850 Order Import with 997.
7. In the Import Options section, set Import From to FTP and fill out the FTP fields with the details provided by CommerceHub. Make sure to check Use Passive and Use Secure FTP.
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 QVC following the 856 EDI format.

Before you move on, create a Saved Search for orders. Recommended filters are:

• Company – The company you created for the integration
• Order Status – InProcess Or Completed
• Shipping Status – FullyShipped
• Payment Status – Charged
• Tracking Uploaded – No

Automate Tracking Export

To create a Scheduled Task that 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 QVC 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 fields with the details provided by CommerceHub. Make sure to check Use Passive and Use Secure FTP.
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.

---

Inventory Export

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

If you mark a product as Discontinued on the Product Details Page, the plugin will send the date of discontinuation to QVC as well as the next available date from the corresponding custom product column.

Optionally, you can enable only specific products for QVC by setting their QVC_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 QVC_Enabled column, and Save.
• For multiple products in bulk: follow the steps to Bulk Update Products and use the QVC_Enabled column – set it to True for all products you want to enable.

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

Next, create a Saved Search for products filtered by QVC_Enabled – True. Optionally, you can add more filters to the search to narrow down the export further.

Automate Inventory Export

To create a Scheduled Task that 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 QVC.
7. In the Export Options section, set Export To to FTP and fill out the FTP fields with the details provided by CommerceHub. Make sure to check Use Passive and Use Secure FTP.
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.

---

Configure PDF Invoices

This plugin creates packing slips with information about your QVC orders and the products they include. This plugin doesn’t require a scheduled task.

To set up the invoice plugin:

1. Go to the Company Settings of the company you created for the integration
2. Click Toolbox and select Invoice Settings.
3. Click Per Channel Preferences.
4. For Website, select Plugin > QVC General PDF Invoice.
5. Click Save.

---