How To

Creating Parent / Child Relationships in Bulk

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. 

 

Prerequisites


You should be familiar with the following topics before continuing:

 

Video


Creating 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 Bulk


Complete the following steps related to this task:  

  1. Download the ChannelAdvisor Bulk Upload Spreadsheet .
  2. The first row will contain the Parent SKU. All SKUs below that SKU will be the Child SKUs of the parent. Note that the Parent SKU has no quantity listed.
  3. Further down the spreadsheet you'll need to fill in the Classifications and the Image URLs.
    • Be sure to fill the same classification for both the Parent and the Child SKU.
    • The Image URL field can contain multiple file names for images separated by a comma and a space.
    • For example, if that SKU will have (2) images, the spreadsheet cell would look like 'image_1.jpg, image_2.jpg'.
    • You would need to upload the images to the server prior to uploading the spreadsheet.
  4. Add the Relationship Name for this variation in both the Parent and Child SKUs.
    • The Variation Parent SKU column is where you will inform ChannelAdvisor Complete of your association between Parent SKU and Child SKU. Note how the Parent SKU name is titled Parent .
    • All Child SKUs underneath the Parent will have the Parent SKU name populated in that cell.
  5. Fill in your attributes and their values.
    • Be sure the attributes are listed exactly as you have created them previously in your Inventory Relationship.
  6. Once complete, save the file in a text-tab delimited format and upload into the ChannelAdvisor Complete application.
Please Note

Common issues to watch out for:

   1. If you are planning to update your Parent / Child relationships via Bulk Update, be sure the Parent exists either in the spreadsheet or was added through the User Interface.
   2. It is possible to upload Children only (without the Parent) via Bulk Upload, but you must have declared the Parent in the system already through the User Interface.
   3. If you are uploading both Parent and Children via bulk upload, the Parent must come before the Children on the spreadsheet.


Examples


The 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. 

 

This image shows the relationship name and the Variation Parent SKU columns. The Relationship Name for this variation has been populated for the parent SKU and each Child SKU. The Variation Parent SKU column is where you will inform ChannelAdvisor Complete of your association between Parent SKU and Child SKU. For the parent SKU you simply will type the word "Parent". All Child SKUs underneath the Parent will have the Parent SKU name populated in that cell. 


 

 

Related Tasks 


Complete 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. 

 

Prerequisites


You should be familiar with the following topics before continuing:

 

Video


Creating 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 Bulk


Complete the following steps related to this task:  

  1. Download the ChannelAdvisor Bulk Upload Spreadsheet .
  2. The first row will contain the Parent SKU. All SKUs below that SKU will be the Child SKUs of the parent. Note that the Parent SKU has no quantity listed.
  3. Further down the spreadsheet you'll need to fill in the Classifications and the Image URLs.
    • Be sure to fill the same classification for both the Parent and the Child SKU.
    • The Image URL field can contain multiple file names for images separated by a comma and a space.
    • For example, if that SKU will have (2) images, the spreadsheet cell would look like 'image_1.jpg, image_2.jpg'.
    • You would need to upload the images to the server prior to uploading the spreadsheet.
  4. Add the Relationship Name for this variation in both the Parent and Child SKUs.
    • The Variation Parent SKU column is where you will inform ChannelAdvisor Complete of your association between Parent SKU and Child SKU. Note how the Parent SKU name is titled Parent .
    • All Child SKUs underneath the Parent will have the Parent SKU name populated in that cell.
  5. Fill in your attributes and their values.
    • Be sure the attributes are listed exactly as you have created them previously in your Inventory Relationship.
  6. Once complete, save the file in a text-tab delimited format and upload into the ChannelAdvisor Complete application.
Please Note

Common issues to watch out for:

   1. If you are planning to update your Parent / Child relationships via Bulk Update, be sure the Parent exists either in the spreadsheet or was added through the User Interface.
   2. It is possible to upload Children only (without the Parent) via Bulk Upload, but you must have declared the Parent in the system already through the User Interface.
   3. If you are uploading both Parent and Children via bulk upload, the Parent must come before the Children on the spreadsheet.


Examples


The 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. 

 

This image shows the relationship name and the Variation Parent SKU columns. The Relationship Name for this variation has been populated for the parent SKU and each Child SKU. The Variation Parent SKU column is where you will inform ChannelAdvisor Complete of your association between Parent SKU and Child SKU. For the parent SKU you simply will type the word "Parent". All Child SKUs underneath the Parent will have the Parent SKU name populated in that cell. 


 

 

Related Tasks 


Complete the following tasks related to this topic 

0
Your rating: None Average: 2.7 (3 votes)
0
Your rating: None Average: 2.7 (3 votes)