Orion to WooCommerce Field Mapping
Orion to WooCommerce Field Mapping
When the Full Product Data Upload is turned on in Orion's WooCommerce integration on [M - E - W - 2], Orion becomes the point-of-truth for the following data fields in the WooCommerce product catalog. Orion will add, update, and delete products as needed to keep the product catalog up-to-date with this information. These fields should only ever be updated in Orion; Orion will handle synchronizing this information on WooCommerce.
| WooCommerce API Field | hpCommerce Orion Field | Static Value | Applies to Simple Products? | Applies to Master Products (Variable)? | Applies to Variants? | Note |
| name | Alternate Web Title | X | X | |||
| type | static | simple / variable | X | X | Used when adding new parts to WooCommerce | |
| description | Alternate Web Description | X | X | X | ||
| sku | [PLC]-[Part Number] | X | X | X | ||
| regular_price | configurable | X | X | User specifies which price level (Price A - H or List Price) to send | ||
| sale_price | Sale Price | X | X | User specifies whether or not the sales price is synced | ||
| date_on_sale_from | Sale Price Good From | X | X | User specifies whether or not the sales price is synced | ||
| date_on_sale_to | Sale Price Good To | X | X | User specifies whether or not the sales price is synced | ||
| manage_stock | static | TRUE | X | X | Used when adding new parts to WooCommerce | |
| stock_quantity | Quantity Available - Safety Stock | X | X | User can specify a "safety stock" number which decreases the quantity available sent | ||
| backorders | Allow Backorders on WooCommerce | X | X | User can specify whether or not this field is updated via the "Update Backorder Property" on [M - E - W - 2] and must specify the default value. Backorders must be allowed in Orion for this option to be sent. | ||
| weight | Net Weight | X | X | |||
| dimensions.length | Length | X | X | |||
| dimensions.width | Width | X | X | |||
| dimensions.height | Height | X | X | |||
| categories | Categories | X | X | Master categories and associated Sub-Categories in Orion are synced to WooCommerce. Only category names are sent to WooCommerce. | ||
| images | Images | X | X | X | Uploaded to Media Library, variants only support one image. Images are sent with the specified caption or the special caption text depending on configuration. | |
| metadata (configurable key) | PLC | X | X | X | ||
| metadata (configurable key) | Manuf PLC | X | X | |||
| metadata (configurable key) | Part Number | X | X | X | ||
| metadata (configurable key) | Manuf Part Number | X | X | |||
| metadata (configurable key) | OEM | X | X | |||
| metadata (configurable key) | Year From | X | X | X | ||
| metadata (configurable key) | Year To | X | X | X | ||
| metadata (configurable key) | Unit | X | X | X | ||
| metadata (configurable key) | Description | X | X | X | ||
| metadata (configurable key) | Long Desc | X | X | |||
| metadata (configurable key) | Keywords | X | X | X | ||
| metadata (configurable key) | Aliases | X | X | Aliases are sent with PLC and Part Number concatenated (once with nothing between and once with a dash between) | ||
| metadata (configurable key) | Attachments | X | X | X | Local file attachments with a type of TECHNICAL DRAWING, uploaded to Media Library | |
| metadata (configurable key) | Attachments | X | X | X | External URL attachments with a type of TECHNICAL DRAWING | |
| metadata (configurable key) | Attachments | X | X | X | Local file attachments with a type other than TECHNICAL DRAWING, uploaded to Media Library | |
| metadata (configurable key) | Attachments | X | X | X | External URL attachments with a type other than TECHNICAL DRAWING | |
| metadata (configurable key) | Required Product Note | X | X | X | ||
| metadata (configurable key) | Important Product Note | X | X | X | ||
| attribute (configurable ID) | Year From to Year To | X | X | Orion sends a list of all years from Year From through Year To to a global attribute in WooCommerce, if configured | ||
| Addify: Role Based Pricing | configurable | X | X | User configures the roles in WooCommerce and assigns a price level to each role in Orion | ||
| attributes | Master Product Attributes | X | Master attributes in Orion are synced to WooCommerce | |||
| attributes | Part Attribute Options | X | X | Master attribute options in Orion are synced to WooCommerce |