Channel Mapping
After importing new products, you must map them to a marketplace and posting template with a Channel Item Mapping import.
On the sidebar, under Data Management, click Import/Export.
First go to the Exports tab and click + New Export, and select Channel Item Mapping from the dropdown. Then click Export.
Download the exported catalog by clicking the cloud symbol to its right and open the file.
Delete the first 5 columns ‘id’, ‘created_at’, ‘created_by’, ‘updated_at’, and ‘updated_by’.
Delete the product_id column.
Enter the recently imported product SKUs in the product_sku column.
To get the subscription id, go to the Integrations tab on the sidebar under Organization. The subscription id is the ID number to the left of the sales channel in the Sales Channel section. Enter that number in the subscription_id column.
To get the posting template id, go to the Integrations tab on the sidebar under Organization. Click Edit by the subscription/marketplace and click the Posting Templates tab. The posting template id is the ID number to the left of the posting template in this section. Enter that number in the posting_template_id column.
The listing_action column allows three options: FULL, which sends full listing content to the marketplace; ZERO, which sends full content with 0 inventory (regardless of actual inventory) to the marketplace; and UNLIST, which unlists (retires) the SKU.
It is possible to add multiple mappings per SKU by creating additional rows with that SKU and entering the additional subscription and posting template ids in those rows.
Once finished creating the file, save as CSV UTF-8 and click + New Import on the Imports tab.
Select ‘Channel Item Mapping’ from the Item Type dropdown and then select the file by dropping it or browsing.
You will now see a list of all your file’s attributes (source headers) next to data mapping fields. In the ‘Select Field’ box choose the Acenda mapping to use for that attribute. You can only use a mapping once per upload. The system will automatically find the closest match if your header is already an Acenda mapping. Check the box to the attribute’s left to enable it.
To save the upload file format for future use, check the box next to ‘Save custom import profile for future use’ and give the profile a name in the box which appears once checked. For a channel item mapping, you only need to do this once as all uploads will have the same 6 fields. You can then select that saved profile from the ‘Import Profile’ dropdown where it says ‘- - Custom Import Profile - -’ to automatically map future channel item mapping uploads with the same column headers your initial upload used.
If the upload contains only new SKUs leave the next two boxes unchecked. If adding new SKUs as well as updating existing SKUs check the ‘Overwrite any records that have the same ID’ box, and if only updating existing products check the ‘Only update existing records’ box.
Click Start Import.