Documents
HomeGlossary
Learn Shopify
Learn Shopify
  • Shopify Integration
    • Introduction
    • Products
      • Product Download
      • Updating Product Details
      • Deleting Products
      • Creating/Deleting Products with Shopify Webhooks
      • Gift Cards Download
      • Kit Products Download
      • Product Synchronization for Multiple Shopify Stores
    • Inventory
      • Inventory Synchronization
      • Location Mapping
      • Inventory Synchronization of Gift Cards
      • Inventory Synchronization of Kit Products
    • Orders
      • Order Download
        • thruDateBuffer and bufferTime
      • Order Approval for Fulfillment
      • Order Updates
      • POS Sales Download
      • Gift Cards Order Download
      • Kit Order Download
    • Order Fulfillment
      • Gift Cards Order Fulfillment
      • Kit Order Fulfillment
    • Order Cancellations
      • Complete Order Cancellation
      • Partial Order Cancellation
    • BOPIS Orders
      • Shopify PDP Experience
      • BOPIS Order Download
    • Pre-orders and Backorders
      • Presell Catalog Management
      • Presell Catalog Synchronization
    • Order Returns
      • Import Returns from Shopify
      • Shopify POS Exchanges
  • Setup Shopify
    • Install HotWax Commerce App
    • Multiple Store Setup
    • Required Permissions from Shopify
    • Enable BOPIS/Pre-order on Shopify
    • Integration Mappings
      • Locations
      • Shipping Method
      • Sales channel
      • Payment Method
      • Product Type
    • Troubleshooting
      • Facility Mapping Discrepancy
  • Synchronization Flows
    • Initial Product Sync
    • Initial Order Sync
    • Initial Inventory Sync
    • Troubleshooting
      • Product Sync
      • Order Sync
      • Inventory Sync
  • Additional resources
    • Kit Products
    • POS Completed Orders
Powered by GitBook
On this page
  • Initial Product Download from Shopify to HotWax Commerce
  • Product data from Shopify is mapped in HotWax Commerce fields as outlined in the following table:

Was this helpful?

Edit on GitHub
Export as PDF
  1. Shopify Integration
  2. Products

Product Download

Learn how launch the initial product download from Shopify.

PreviousProductsNextUpdating Product Details

Last updated 21 hours ago

Was this helpful?

Initial Product Download from Shopify to HotWax Commerce

Merchants can schedule an Import Products in Bulk job in HotWax Commerce to download existing product details from Shopify, including Stock Keeping Unit (SKU) code, Universal Product Code (UPC), Shopify ID, Price, Tags, and Weight. This should be done before to ensure that products are available for incoming sales orders. The import process consists of two steps:

  1. Downloading from Shopify- HotWax Commerce sends an to Shopify to download products. In response, Shopify returns product data in JSON format. Shopify permits downloading 250 products per API call. To prevent large data file errors, HotWax Commerce downloads only 100 products per call.

  1. Product Creation in HotWax Commerce- After downloading, the JSON files are read from the file system, and product records are created in HotWax Commerce's database through the Process bulk imported files job. If any data issues arise, error logs are recorded for later correction.

Product data from Shopify is mapped in HotWax Commerce fields as outlined in the following table:

  1. Parent Product

A virtual product, also known as a parent product, does not have a set size or color. When using HotWax Commerce, all fields in the product JSON are imported, but only relevant fields are processed to improve system efficiency. Here's how parent product fields are mapped in Shopify and HotWax Commerce:

S.No.
Fields in Shopify
Fields in HotWax Commerce

1

ID

Shopify Product ID

2

Title

Product Name

3

Body HTML

Product Content

4

Vendor

Brand

5

Product_type

Categories

6

Tags

Tags

7

Variant

Variant

8

Media

Overview

  1. Variant Product

The parent product comes in various sizes and colors, resulting in multiple variants. With HotWax Commerce, all of these variants can be downloaded. Here's how product variant fields are mapped in Shopify and HotWax Commerce:

S.No.
Fields in Shopify
Fields in HotWax Commerce

1

Product Variant ID

Shopify Product ID

2

Title

Product Name

3

Options

Feature

4

Image

Image

5

Parent Product

Parent Product

6

Price

Price

7

SKU

SKU

8

Quantity

View inventory

9

Shipping

Shippable

10

Product Type

Product Type

11

Weight

Weight

12

Metafields

Product Tag

Importing Newly Added Products Regularly

Shopify merchants create new products for two reasons::

  1. When a new product is added to the catalog.

  2. When users prefer to delete the existing product and create a new one with updated fields

To make it easier to keep both Shopify and HotWax Commerce's product catalogs up to date, Shopify merchants can schedule an Import Products job that runs every 15 minutes. This job checks the created_at field of products in Shopify and identifies any products that were created after the last run of the job. Any newly created products are then imported into HotWax Commerce's product catalog through the Process bulk imported files job. By doing this, HotWax Commerce's catalog stays synchronized with Shopify's catalog, ensuring that merchants have access to the most up-to-date product information.

It is recommended to run this job every 15 minutes. However, the frequency of the job can be set as per a merchant’s business needs.

Managing Sales Orders For Products That Are Not In HotWax Commerce

When orders are placed on Shopify, they are also transferred to HotWax Commerce. However, sometimes an order might include a newly launched product in Shopify that has not yet been synced with HotWax Commerce. This can cause the order download to fail if the product import job has not yet run. To prevent this, HotWax Commerce creates a temporary placeholder product for the new item. Once the product import job is run, all the necessary information such as the product name, brand, price, weight, and so on are added to the placeholder product. This ensures that the order download is successful and the customer receives their product.

Shopify has multiple product identifiers, such as Shopify Product ID, Product SKU, Product Name, and UPCA. Therefore before importing products, it is important to set up the primary product identifier that will be mapped with the product ID in HotWax Commerce. The primary product identifier can be set up in HotWax Commerce when as per retailers' requirements.

API request
setting up a new product store
importing orders
Fig.1: Configuration to run `Import Products in Bulk` in the `Job Manager` App
Fig.2(i): Products in Shopify
Products downloaded in HotWax Commerce
Fig.3(i): Variant product in Shopify with details
Fig.3(ii) : Variant product in HotWax Commerce with details
Fig.4: Configuration to run `Import Products` in the Job Manager App