Channels
      Back to home
      1. Help Center
      2. Sharing your data
      3. Channels

      Uploading a CSV template into your CSV or XML Channel

      How to upload a CSV template into your Channel to mirror specific requirements

      Many third party channels (Amazon, Wayfair, eBay, Home Depot, and more) have their own set of requirements when it comes to product data. For each channel you need a different set of attributes (some of them being mandatory, others optional) that should come in a specific naming convention and format. Usually this information is provided in a spreadsheet template that needs to be filled out. In this article you will learn how to upload any CSV template into your CSV or XML Channel to mirror any requirements. 

       

      Uploading a CSV Template

      Mapping Attributes 

      Formatting the CSV Template

       

      *Skip to any section in this article by clicking on the links above

      Uploading a CSV template

      Within a Channel you are able to upload a CSV file template to mirror any template for a given channel. This way, you can directly match attributes living in your PIM with the ones in the CSV template - which will save you a lot of time!

      ℹ️ The CSV template should contain a different attribute name in the header row of each column in order to be read by our system correctly.


      To upload a CSV template, simply:

      1. Head to the 'Attributes' tab within your CSV or XML Channel.
      2. Click on 'Upload CSV template.'

      channel-attributes(2)

      3. You'll be asked to drag a file to the designated area or click to upload a file from your computer. Once it loads, click 'Next'.

      csv-upload

      4. This will generate a preview of the columns in your template. You can adjust the settings if needed, then click 'Next.'

      csv-file

      5. You'll then be asked if you want to auto-match attributes if the fields in your template are the same as your attributes in Plytix. Click 'Confirm' to finish the upload process.

      auto-match columns

      ℹ️ If you choose to auto-match columns with existing attributes, you'll receive a notification at the bottom of your screen of how many attributes were successfully matched. If you do not wish to auto-match or if not all attributes were automatically matched, proceed to the section below - "Mapping Attributes" - to complete the matching process.

      Mapping Attributes

      Once you have uploaded the CSV template, you can match the required fields for the specific Channel with the attributes living in your PIM. 

      To do so:

      1. Click on the attribute you wish to map


        csv-match(1)


      2. Map it either with an already existing attribute OR create a computed field


        matching-panel(1)

       

       

      ℹ️ The attributes that you leave unmatched will still get displayed in the header row of the CSV file generated by this Channel but will not display any values.

       

      If you have already some attributes in your Channel (by either adding them manually or uploading a CSV template) and choose to upload another CSV template you will have two options:

      1. Add attributes from the CSV template to the channel
      2. Remove all and replace existing attributes

      attributes-setting(1)


      Formatting the CSV Template

      When uploading a CSV template, not only the required output labels will be automatically displayed in the final URL feed generated by the Channel, but also their order. 

      The attributes will automatically be displayed in the manual sorting order of the template file. This means you will save a lot of time not having to manually change under the 'Format' tab the output labels and the order of the attributes in which they should be displayed for each channel you are sending your data to. 

       

      format-tab(1)

      💡 Learn more about defining your data format here.

      What's next?

       

      Is there anything you were hoping to find in this article that is missing? Did this article answer the questions you had? Let us know in our Help Center feedback form! 🙌

       

      If you have any questions just contact us by clicking on the chat icon in the bottom-right corner and we'll get back to you as soon as possible...


      and please let us know 👇