Magento 2.0 (Adobe Commerce) product catalog
The Cin7 Core Magento Catalog allows you to download products from Magento, list Cin7 Core products in Magento, break the link between a Cin7 Core product and its Magento listing, and update quantities in Magento based on the available stock in Cin7 Core.
Downloading products
Products can be loaded from Magento to Cin7 Core in the Catalog tab by clicking Download → Products. This operation may take some time, depending on the number of products in your store's catalog.
Each product variation in Magento must have a unique SKU. Configurable products require individual simple products for each variation. These simple products will have individual SKUs in Cin7 Core.
When downloading products, Cin7 Core tries to match existing products first to avoid creating duplicates. Matching is performed by item or variant SKU.
Product field mapping
Data mapping for products between Cin7 Core and Magento is as follows:
Fields in Cin7 Core do not have a field in Magento are left blank.
| Cin7 Core |
MAGENTO 2 |
|---|---|
ProductInfo |
Product |
Guid ID |
-- |
Guid FamilyID |
-- |
EcsFamilyID |
id |
ProductID |
id |
VariantID |
id of variation in Magento2 |
Name |
name |
SKU |
sku |
Description |
CustomAttributes["description"] |
ShortDescription |
-- |
Category |
CustomAttributes["category_ids"] - deepest category |
Brand |
-- |
Type |
type_id |
Option1Name |
productAttribute.options.label[1] |
Option2Name |
productAttribute.options.label[2] |
Option3Name |
productAttribute.options.label[3] |
Option1Values |
productAttribute.options.value[1] |
Option2Values |
productAttribute.options.value[2] |
Option3Values |
productAttribute.options.value[3] |
Tags |
-- |
DimensionUnits |
-- |
Length |
CustomAttributes["ts_dimensions_length"] \ CustomAttributes["length"] |
Width |
CustomAttributes["ts_dimensions_width"] \ CustomAttributes["width"] |
Height |
CustomAttributes["ts_dimensions_height"] \ CustomAttributes["height"] |
Weight |
weight |
Quantity |
stock_item.qty |
WeightUnits |
-- |
UnitOfMeasure |
-- |
Barcode |
CustomAttributes["barCode"] |
MinimumBeforeReorder |
extension_attributes.stock_item.min_qty |
ReorderQuantity |
-- |
AverageCost |
CustomAttributes["cost"] |
Price Tier (chosen in settings) |
Price |
Sale Price Tier (chosen in settings) |
CustomAttributes["special_price"] |
PriceTier1 |
tier_prices.value |
PriceTier2 |
tier_prices.value |
PriceTier3 |
tier_prices.value |
PriceTier4 |
tier_prices.value |
PriceTier5 |
tier_prices.value |
PriceTier6 |
tier_prices.value |
PriceTier7 |
tier_prices.value |
PriceTier8 |
tier_prices.value |
PriceTier9 |
tier_prices.value |
PriceTier10 |
tier_prices.value |
ECSCustomField3 |
AttributeSetId |
List<Image> Images |
Images |
SaleTaxRuleID, SaleTaxRuleName |
CustomAttributes["tax_class_id"] |
Manage the Catalog
There are two possible statuses for products in the Catalog: Not Listed and Listed. To be listed, every item needs to have a description, item image, and default location specified.
Note: Cin7 Core does not update category or images for an existing product in Magento, category and images are pushed only upon product creation.
Note: Cin7 Core products can only be synced as a simple product (not a bundle) in Magento even if it has a bill of material in Cin7 Core. Cin7 Core product families are synced as configurable products in Magento. This is due to a limitation of the integration.
WARNING! Updating products from the catalog will update the stock level in Magento regardless of the Update Stock Levels in Magento setting status.
List or update a product on Magento
Under the Catalog tab, click the product on the list.
Specify an Additional attribute set for the product. It is required to specify the Magento Attribute Set in order to create a product in Magento. Cin7 Core products must have an Attribute Set specified to be listed.
Enable or disable stock level syncing at the individual product level.
Click List on Magento for a new listing, or Update on Magento for a product that has already been listed.
Save your changes.
Unlist a product on Magento
Click on the product in the Catalog tab.
Click Unlink to unlist the product. This also deletes the link between the products in Magento and Cin7 Core, although the items remain in both systems.
Save your changes.
Remove a product from Magento
Bulk Listing
All products in Cin7 Core can be bulk-listed to Magento through the Bulk Listing tab. If products are already listed, this action will update them.
When Use Buffer Inventory setting is enabled from the Setup tab, Sync Quantity and Buffer Inventory quantity will be added as fields to the Bulk Listing tables alongside stock availability. See Buffer Inventory for more information.
To list products on Magento in bulk:
Go to the Bulk Listing tab.
Select products to upload in bulk. You can select products by Category, Brand, Family, Product Tag, Attribute Set, Listing Status, Products Listed in (another channel) and through manual search.
Note: If you have multiple stores in another sales channel, e.g. two different Shopify stores, these will be displayed separately in the list of sales channels from which products can be selected for upload.
To automatically enable products in Magento after the bulk listing, set the Create products in enabled status button to Yes.
Specify an Attribute Set for the product. It is required to specify the Magento Attribute Set in order to create a product in Magento. Cin7 Core products must have an Attribute Set specified to be listed.
Click List to upload all selected products. You can also Unlist and Unlink products in bulk in the same way.
Buffer Inventory
Instead of showing actual inventory values in e-Commerce storefronts, many retailers prefer to display an estimated display quantity where there is a safe buffer stock on their backend to avoid overselling products. Cin7 Core allows for an inventory buffer on stock quantities pushed to Magento, both for the whole channel and at the product level.
Buffer inventory levels for the whole channel are controlled from the Setup tab. Update Stock Levels in Magento setting must be enabled.
Use Buffer Inventory: Displayed when Update Stock Levels in Magento is enabled. Allows for an inventory buffer on stock quantities pushed to Magento. Enabling this setting will enable the Buffer Inventory field.
Buffer Inventory: Displayed when Use Buffer Inventory is enabled. Enter an integer number of stock to act as a buffer. Sync Quantity passed to Magento when updating stock levels will be equal to Actual Stock - Buffer Inventory.
When this setting is enabled, Sync Quantity and Buffer Inventory quantity will be added as fields to the Catalog and Bulk Listing tables alongside stock availability. However, sync quantities will only be updated in the channel if the user updates or lists a product.
Buffer Inventory for the whole channel can be overwritten by a product level buffer from either the Catalog or Bulk Listing page (Use buffer inventory must be enabled from the channel Setup tab). The product level buffer value will ALWAYS override the value set on the Setup tab. If the Setup tab buffer inventory value is changed, this will not affect products with product level buffers.
Note: Product level inventory buffer is disabled by default. In the case of wanting to turn off inventory buffer for certain products only, the user will need to enable buffer inventory and enter a value to apply it to the whole catalog, THEN set product level buffer to 0 for those products, then update or list the item to apply changes.
If the user wishes to apply inventory buffer ONLY to one or more specific products, inventory buffer should be enabled on the Setup tab and set to 0. Then, product-level buffer inventory can be enabled and configured for products from either the catalog or bulk listing page. You will need to list or update the item to apply changes.
On the Catalog page:
Click on a listed or unlisted item to open a pop-up window and slide Use Product Level Buffer Inventory to enable. You can then enter an integer value for Product level buffer which will overwrite the channel buffer value. You will then need to Update or List the product for the new stock level quantity to be displayed in the channel. Save and Close to continue.
On the Bulk Listing page:
Use this to update product level buffer for multiple items at once. Use the search box and filter options to filter items to list/update in bulk.
The Use Buffer Inventory menu allows you to Turn on product level setting, Remove product level setting, or Don't update existing setting.
Turning on product level setting allows you to then enter an integer value for Product level buffer. Click List to overwrite the channel buffer value for the filtered products with the product level buffer.
Selecting Remove product level setting, then List, will remove the product level setting from the filtered products and return them to the channel buffer inventory value.
Selecting Don't update existing setting will leave all buffer values, including product level buffer values, unchanged when updating listings or making a new listing.
Update stock quantities
Trigger the update of stock levels in other Magento stores and other connected eCommerce channels. This is performed by clicking Update Quantities in Magento from the Catalog tab.