Working with Projects
      Back to home
      1. WakeupData Knowledge base
      2. WakeupData Connect
      3. Working with Projects

      How to import your product data feed?

      In this article, we will guide you through the process of importing your product data feed.

      The first step in creating a project is to import your product data to the Wakeupdata platform. You have several ways of importing your product data, which we will describe below. ( Product data feed import initial step )


      1. Feed on URL

      By selecting Feed on URL you can import XML, CSV, TXT, or JSON files - simply insert the URL of your product data feed and click "Test fetch data". Please scroll down for the second step in the process.

       

      Feed on URL

      Feed-on_url-insert-link

      If you are importing a JSON file, please reach out to support@wakeupdata.com. JSON files need to be converted and one of our support specialists will make sure to guide you through the process.


      2. Use Wakeupdata apps for CSM systems like Shopify, WooCommerce, PrestaShop Magento 1&2, Ucommerce, or Bluestone PIM. 

      When selecting one of the available apps, please read the instructions on the left side to install and receive the keys for importing your product data. 

      Shopify-app

      The second step in creating a project is to map your product data.


      Once you selected the right source of data, its time to map your data and run the import for the first time. The system will fetch the data from the source and validate all the available fields, furthermore press "Continue" and the system will automatically map all the available fields.

      Continue-to-automapping

      Furthermore, select a unique identifier. A unique identifier is an attribute that is unique for each product individually, such as Unique Id, GTIN/EAN, MPN numbers.

      Select-unique-identifier

      Screenshot 2020-08-11 at 15.21.13

      Once you press "Finish", the system will automatically import your product data feed for the first time. Depending on the size of the file, it might take from a couple of seconds to a couple of minutes so please be patient 😊

      first-run

      Once your first import is done, you will see the number of products imported and you can start working on the project. 

      First import

      Remember to adjust the time for your updates. For more information about schedules, see this article.

       

      How to merge CSV using Google Sheets?

      1. Create a new project or add as an additional step to an existing project
      2. Select “Google Spreadsheet” as shown in the picture below

      google spreadsheet

      3. Go to the Google Sheet which contains your data. If you have a CSV file on your computer you can import it into Google Sheets easily. On the Google Sheet go to “File” and choose “Publish to the web” as shown below.

      4. The menu opens the following selections

      5. Change “Entire Document” to a given sheet, this is normally the only sheet in the Google Sheet 
      6. Change “Web page” to “Comma-separated values” shown below

      7. Click “Publish” and copy the displayed link into the WakeupData platform under “Google spreadsheet link”