Product Custom Column Mapping
Product custom column mapping is used to map Acumatica Attributes to SellerCloud Connector Custom columns.
If you wish to sync specific data from Acumatica to a separate custom field that you created in SellerCloud Connector, you can use this mapping option, and the data will be updated depending on the mapping.
Scenario-1 Enabling Product
- If the attributes are not assigned to the item class, then assign the attribute to the item class follow the below steps to create Item Class.
![Attribute Screen](/wp-content/uploads/2023/12/Attribute-Screen-1-1024x489.png)
- You need to navigate to the [GENERAL] and click on the Pencil icon in the item class.
![Add the Attribute](/wp-content/uploads/2023/12/Add-the-Attribute-1-1024x518.png)
- Click on [+] icon and add the attributes and click on [Save].
- To assign the attribute You need to [save] stock item screen.
![Item Classes](/wp-content/uploads/2023/12/Item-Classes-6-1024x524.png)
- You can select the [Value] of the attribute from the drop-down and save the product.
![Attribute Screen](/wp-content/uploads/2023/12/Attribute-Screen-2-1024x482.png)
The product was not set up for SellerCloud Connector; to sync the data, you need to click on [Kensium Commerce] then a new screen will appear with connector.
- Toggle the checkbox then the [Site configuration] will display.
-
You can select the product type from the drop-down menu:
- MAIN SKU
- SHADOW SKU
- You need to click on the [Save].
![Site Configuration](/wp-content/uploads/2023/12/Site-Configuration-1-1024x501.png)
- To access product custom column mapping, you need to click on [Product custom column Mapping] under [Configurations]. Then you will be redirected to a new page.
- This relates to the mapping of attributes.
- You must search for the [connector ID].
- Click on [Initialize columns], then a pop-up will appear, where you need to enter [Product ID] to fetch the custom column mapping.
- You need to enter [Ref SKU for Product C], this should match with SellerCloud Connector.
- This allows you to Fetch the customized column mapping.
![Add custom Column](/wp-content/uploads/2023/12/Add-custom-Column-1024x484.png)
- Click on [OK].
To make properties visible in a custom column. The attribute needs to be enabled by schema management.
- Upon Refreshing the Schema, you will be able to view option and feature.
![Attributes in Product](/wp-content/uploads/2023/12/Attributes-in-Product-1-1024x478.png)
- You can view the connected connector in the [logs] under [Reports].
![Connector connected in logs](/wp-content/uploads/2023/12/Connector-connected-in-logs-1024x473.png)
- The DEMO1 is pushed or synced into SellerCloud Connector.
- To view the DEMO1 in SellerCloud Connector follow the below screenshots.
![SellerCloud Connector instance](/wp-content/uploads/2023/12/SellerCloud-Connector-instance-1-1024x489.png)
![DEMO1 Synced in SellerCloud Connector](/wp-content/uploads/2023/12/DEMO1-Synced-in-SellerCloud-Connector-1024x489.png)
- The chosen company name, attribute, and type, along with the configured Connector ID, will sync to the SellerCloud Connector.
Scenario-2 Enabling Kit Specification
Inventory
The Quantity must be added, you need to search for [Receipts] in the Global search bar.
- Click on the [Receipts] under transactions.
![Receipts Screen](/wp-content/uploads/2023/12/Receipts-Screen-1-1024x495.png)
- You will be redirected to a new screen with all the generated receipt, click on [+] icon.
![Receipts Screen](/wp-content/uploads/2023/12/Receipts-Screen-list-1024x484.png)
- You will be redirected to a new screen, click on the [+] icon and search for the existing [Inventory ID].
![Select Inventory ID](/wp-content/uploads/2023/12/Select-Inventory-ID-1024x497.png)
- Search You need to search for the [warehouse] and [Location].
![Select Warehouse](/wp-content/uploads/2023/12/Select-Warehouse-1024x498.png)
- You need to enter the [Quantity], [Unit Cost], [Ext Cost] and click on [REMOVE HOLD].
![Remove Hold](/wp-content/uploads/2023/12/Remove-Hold-4-1024x511.png)
- Click on [Release Hold] and you will get a pop-up that [The operation has completed].
- You can view the connected connector in the [logs] under [Reports].
![Quantity synced in logs](/wp-content/uploads/2023/12/Quantity-synced-in-logs-1024x486.png)
- The Inventory is pushed or synced into SellerCloud Connector.
- You can view inventory in SellerCloud Connector.
![Inventory in SellerCloud Connector](/wp-content/uploads/2023/12/Inventory-in-SellerCloud-Connector-1024x404.png)
- You will be redirected to a new screen.
![Select Product Type](o/wp-content/uploads/2023/12/Select-Product-Type-1-1024x503.png)
-
You must enable the check box for [Enable Kensium Commerce Framework] and then enable the check box for [Connector Type] and select the [product type] from the drop-down menu:
- MAIN SKU
- SHADOW SKU
- Click on [Save].
- Similarly, you need to add [Default price] for the remaining child’s items and map with Kensium Commerce.
- You need to navigate to the [Inventory] and click [Receipts] under [Transactions].
- Click on [+] icon.
![Receipts](/wp-content/uploads/2023/12/Receipts-5-1024x483.png)
- Click on [+] icon under [Details] and search for the created child items in [Inventory ID].
- Enter the [Quantity].
- Click on [Save].
- Click on [Remove Hold].
![Remove Hold](/wp-content/uploads/2023/12/old-Remove-Hold-1024x451.png)
- Upon on clicking [Remove Hold] the [Reference Nbr.] will appear.
![Release Hold](/wp-content/uploads/2023/12/old-Release-Hold-1024x484.png)
- You need to navigate to [Stock item] and enable the parent item to [Kensium Commerce].
![Stock Items](/wp-content/uploads/2023/12/Stock-Items-15-1024x501.png)
-
You must enable the check box for [Enable Kensium Commerce Framework] and then enable the check box for [Connector Type] and select the [product type] from the drop-down menu:
- MAIN SKU
- SHADOW SKU
- You must enable the [Active] check box and click on [Save].
![Parent Item](/wp-content/uploads/2023/12/Parent-Item-2-1024x505.png)
- To activate the connector, navigate to Commerce Connector and click on [Kit Items], then a new will appear click on [Process Message] then a successful message will pop-up on the screen.
![Kit Items](/wp-content/uploads/2023/12/Kit-Items-1024x482.png)
![Kit items processed](/wp-content/uploads/2023/12/Kit-items-processed-1024x481.png)
You need to navigate to [logs] screen and check for [Kit Item] Sync.
![Log](/wp-content/uploads/2023/12/Log-1-1024x489.png)
- Click on the INFO of Kit Product Sync a new screen will pop-up with the child items.
![Files](h/wp-content/uploads/2023/12/Files-1024x488.png)
- Click on populated file you will be redirected to a new screen with Parent and child items.
![Child items with Parent ID](/wp-content/uploads/2023/12/Child-items-with-Parent-ID-1-1024x488.png)
- To view the Child items in SellerCloud Connector follow the below screenshots.
- You need to navigate to SellerCloud Connector and search for parent item [KITP-23].
![Seach for Kit](/wp-content/uploads/2023/12/Seach-for-Kit-1024x490.png)
- Search for kit in [Catalog] and click on [Kit] a new screen will appear where you can see parent with child items.
![Parent and child items](/wp-content/uploads/2023/12/Parent-and-child-items-1-1024x488.png)