Creating Parent / Child Relationships in BulkConfiguring your inventory to list in a variation format in bulk is a more advanced method of completing this process and is the recommended method for sellers with large inventory and who are comfortable with completing the process in the user interface. To get a full overview of this process please see the Using Variations page. PrerequisitesYou should be familiar with the following topics before continuing:
VideoCreating Variations in Bulk – This video is for sellers who wish to use product variations and add them in bulk using the ChannelAdvisor Upload Spreadsheet. View Transcript How to Create Parent/Child Relationships in BulkComplete the following steps related to this task:
It is possible to upload Children only (without the Parent) via Bulk Upload. The system will create a parent containing only the SKU you provide in the Variation Parent SKU column. But it is expected that you'll complete title, description and other necessary fields in this Parent SKU afterwards. ExamplesThe image below shows the Bulk Upload spreadsheet. The first row will contain the Parent SKU. The shaded row in grey is to call your attention to this SKU. All SKUs below that SKU will be the Child SKUs of the parent. Note that the Parent SKU has no quantity listed. Note: You don't have to structure your upload file in a specific order. Child SKUs don't have to be placed strictly below the Parent SKU in your spreadsheet. The system will identify Parents and relating Children via the Inventory Number of the Parent and the Variation Parent SKUs of the Children – irrespective of the row an item is placed in. The structure used in the screenshots simply serves for better explanation. Related TasksComplete the following tasks related to this topic Configuring your inventory to list in a variation format in bulk is a more advanced method of completing this process and is the recommended method for sellers with large inventory and who are comfortable with completing the process in the user interface. To get a full overview of this process please see the Using Variations page. PrerequisitesYou should be familiar with the following topics before continuing:
VideoCreating Variations in Bulk – This video is for sellers who wish to use product variations and add them in bulk using the ChannelAdvisor Upload Spreadsheet. View Transcript How to Create Parent/Child Relationships in BulkComplete the following steps related to this task:
It is possible to upload Children only (without the Parent) via Bulk Upload. The system will create a parent containing only the SKU you provide in the Variation Parent SKU column. But it is expected that you'll complete title, description and other necessary fields in this Parent SKU afterwards. ExamplesThe image below shows the Bulk Upload spreadsheet. The first row will contain the Parent SKU. The shaded row in grey is to call your attention to this SKU. All SKUs below that SKU will be the Child SKUs of the parent. Note that the Parent SKU has no quantity listed. Note: You don't have to structure your upload file in a specific order. Child SKUs don't have to be placed strictly below the Parent SKU in your spreadsheet. The system will identify Parents and relating Children via the Inventory Number of the Parent and the Variation Parent SKUs of the Children – irrespective of the row an item is placed in. The structure used in the screenshots simply serves for better explanation. Related TasksComplete the following tasks related to this topic (4 votes) Related Topics: (4 votes)
Page last updated: Thu, 02/16/2017 - 11:12
|