Products
Last updated
Last updated
Sometimes store associates place a custom gift card order that is not mapped to the parent product in Shopify and NetSuite. In such cases, retailers face synchronization issues between Shopify and NetSuite due to unmapped gift cards. The custom gift card report serves as a solution to address these synchronization issues. This report shows unmapped products, enabling retailers to manually map these products to NetSuite, inventory them, and associate them with NetSuite IDs.
Field Header | Description | HC Entity |
---|---|---|
Data Selection: The query selects data from the ORDER_HEADER, ORDER_ITEM, and PRODUCT tables. These tables contain information about orders, order items, and products, respectively. By joining these tables and selecting specific fields, the query retrieves necessary details related to custom gift card orders.
Defining Criteria: The query establishes specific criteria to identify custom gift card orders. It filters products based on their product type, ensuring only digital goods are considered. Then, it excludes products associated with a particular ID that is used for gift cards. This criterion ensures that the report focuses exclusively on digital goods matching the characteristics of custom gift cards which are not linked with the ID of the gift cards.
Selecting Necessary Information: Essential information such as order IDs, order names, product IDs, product type IDs, product names, and creation dates is retrieved. This selection provides comprehensive insights into custom gift card orders, enabling retailers to track and analyze their performance over time.
ORDER_ID
It helps in distinguishing one order from another.
OrderHeader.ORDER_ID
ORDER_NAME
This field typically contains a reference or name associated with the order.
OrderHeader.ORDER_NAME
PRODUCT_ID
This is a unique identifier assigned to each product within the system.
Product.PRODUCT_ID
PRODUCT_TYPE_ID
This field denotes the type or category of the product. In this case, it's "DIGITAL_GOOD."
Product.PRODUCT_TYPE_ID
CREATED_DATE
This indicates the date and time when the order was created or processed in the system.
Product.CREATED_DATE
PRODUCT_NAME
The name of the product.
Product.PRODUCT_NAME