Import your feed data

Importing a feed is the first step to syndicating and distributing data. You may also want to add additional feeds to add further information to your product data.

Main Feeds: Every site requires at least one main feed. Adding additional main feeds adds more products and extends the data vertically.

Example: One Main Feed

6149d5531da9f.png
6149d554146e1.png

Example: Two Main Feeds

6149d554e258b.png
6149d555dd77b.png

Additional Data Sources: contain further information on the products to enhance and update the main feed. Additional feeds extend your data horizontally. You can set a feed as an additional feed by selecting the Additional Data Feed button in Content Mode.

6149d556cd203.png

From the drop-down menu, select the column from your main feed that contains your product identifier, for example, ID or SKU.

Enter the name of the matching column in your additional feed. The column name is case-sensitive. Columns in the additional feed that do not appear in the main data feed generate new columns in your product data. Note if columns in the additional feed also exist in the main feed; the values in the additional feed overwrite values for all items with a matching identifier.

6149d557c7890.png
6149d558c50a1.png

Import data from a shop system

Introduction

It is possible to import the product data directly from shop systems.

e458717bcec9c909f2f9bf6d96bbf0a8.png

In Data Sevices, APIs are available for the following shop systems:

To connect to these shop systems through an API, you must have:

  • The API endpoint's URL.

  • An API key/username.

  • An API password/client_secret.

Please note: Usually, API credentials are different from your login credentials for the shop system.

Import your data from Magento systems

For Magento, a connection is possible through SOAP, XML, RPC, and API.

As a basic test, check if your browser can reach the WSDL page via a URL in this format: https://mymagentoshop247.com/api/soap/?wsdl.

If the setup is correct, you should see this information:

5c3600465eaf7aa5a003b9cae81d5e88.png

In Data Services, add the following information:

6149d56a80579.png

Magento SOAP URL: Enter the Magento URL you have set up to access Magento via SOAP.

Username/Password: Enter the Username and Password for your Magento SOAP account.

API multiCall size: Enter how many calls the Productsup platform should make. The default is 500.

Start index/ End index: Specify the first and last values of an ID range for the API to call within.

Store view code: Enter a store view code to download products from a particular store.

If you use Magento 2x, create a user with token-based authentication.

After creating a valid user, you can input the username and password into the data source interface on the Productsup platform. Next, enter the store URL.

6149d56ca65d7.png

The page size determines how many products the Productsup platform should extract with each call to the API. This number is set to 100 by default. You can adjust this depending on the capacity of your hosting server. If the load on the hosting server is too high, reduce the page size accordingly.

You can also adjust the number of concurrent requests by changing the value under concurrency. Note increasing concurrency puts a significant load on your server. Check your server's capacity beforehand to ensure it can handle such an increase.

With Magento Version 2.3, you may add a stock reference code to pull the correct stock information. In this case, switch off Include product details.

The standard way to handle product link information is to explode it, that is, split links into separate columns. However, exploding links can lead to too many columns resulting in an import error. If you receive such errors, set product link information to implode. This action merges all links into a JSON body or discards them.

If you use Magento 2.X using OAuth, you must first authorize the Productsup platform to access your account.

In Data Sources, select Magento 2.x (OAuth) and select your authentication from the dropdown menu.

6149d56def2d7.png

The page size determines how many products the Productsup platform extracts with each API call. The number of calls is set to 100 by default. You can adjust this depending on the capacity of your hosting server.

PrestaShop

Before importing your data from PrestaShop you need to generate an API key in PrestaShop.

To import your PrestaShop data, enter an API Key, the Domain of your PrestaShop, and the Default Language Id. Select Save and run an import.

208c091f816a176aff77092630c44a24.jpeg

Woocommerce

In Woocommerce set up API credentials as follows:

0abb1377ab65bd97d08f64d7d095aaeb.png
ee65474958c2678297622b56c966d1cd.png

In Data Sources, select Add Data Source and run an import.

Troubleshooting

Try adjusting the URL and authorization credentials based on the notifications you receive from Productsup.

It is possible to test REST APIs credentials in a standard browser depending on the shop system and the API version. Most API clients can make both REST and SOAP test requests.

The following are test URLs for the major shop system you can try in a standard browser:

  • Bigcommerce: https://apiusername:api_key@www.exampledomain.com/api/v2/products

  • Shopify: https://api_key:api_password@example-domain.myshopify.com/admin/products.json

  • Woocommerce: https://ck_myconsumerkey:cs_myconsumersecret@example-domain.com/wc-api/v3/products

If the credentials do not work in the browser or API client. Try the following:

1. Add or remove www and other parts of the URL.

2. Add or remove slashes in or at the end of the URL.

3. Try HTTPS or HTTP.

4. Set up new API credentials.

5. Check the shop system forum for common errors.

VTEX

You can import your product catalog from a VTEX shop system in Data Sources.

e388da306bf917579e3291fc31abe107.png

Enter the following information:

Product Endpoint URL: Enter the call for desired products in this input field.

Category Endpoint URL: Enter the call for desired categories in this field. Import only downloads products from selected categories.

Whitelist Columns: Enter the names of the attributes you want to import as columns in this field.

Description: Optionally enter a description for the data source.

The VTEX - API Import with Authentication

Using the basic VTEX API only picks up "public" information. However, you can extract more information by establishing a secure connection to your VTEX environment. To make a secure connection, you must authorize the Productsup platform to access your VTEX account. In Data Sources, configure your import settings as follows:

36807d6e0d3bfa55e7deb36150b9a186.png

Account Name: Enter your VTEX Store Account name.

Environment: You can select the environment to use. Options include vtexcommercestable and vtexcommmercebeta.

App Key : This is the username/key for the Authentication process.

App Token: The password associated with the App Key.

Whitelist Columns (optional): There is a limit on the number of attributes imported from VTEX to the attribute names listed in this text area. If you leave this field blank, the Productsup platform imports every attribute from VTEX.

IBM Commerce on Cloud

To import attributes from your IBM Commerce on Cloud shop system, you need to enter the store and login credentials provided by IBM.

After that, select which of the following action you want to perform in Data Services:

  • Merge - Download parent products and their variants. Variants inherit the attributes from the parent product.

  • Product - Download parent products and variants. Variants do not inherit the attributes from the parent product and can be empty.

  • Category - Download all variant categories per SKU.

Set a Timeout if needed. The default setting is 180. Timeout defines how often the Productsup platform checks if the file is ready. For instance, 180 means the Productsup platform checks your IBM Commerce account every 3 minutes.

6149d575352b7.png

Import data with the Website Crawler

Introduction

The Website Crawler is a service that imports additional product data from the website. You could consider using a Website Crawler in cases where product data is on the website but not available in the data feed.

The Website Crawler converts a website into a feed. This process is different from Data Crawler process that requires a feed. To add a Website Crawler, do the following:

Step 1: Add a data source

Select Add Data Source

9f9c3fae97d9330d6b0277dea5e2aed3.png
6149d578c5888.png

Step 2: Configure settings

The Website Crawler automatically pulls data from your domain but requires some configuration. You must set up the Website Crawler to crawl your domain sustainably.

Also, make sure your web administrators know about any upcoming crawls so that the Website Crawler is not blocked.

Domain: Enter your domain (with www. if needed) without HTTP://

Start URLs: You can enter more than one URL for the Website Crawler to crawl.

Crawl Subdomains: Only activate this option if you have a subdomain, for instance: http://shop.yourdomain.com .

Optional - Crawl Websites via Proxy Server: You can configure your own servers to crawl the website as follows:

Select the Use Proxy Server button.

In the pop-up menu, enter the server host, username, password, and the port.

6dd3da994c197be906d0b063712d8a92.png
72217d6243224093ddbba435989a9e79.png

Link Contains: Enter a URL snippet to limit the number of pages the Website Crawler attempts to crawl. For instance, you could limit it to crawling product sites only.

Filters (include): Only links containing the filter's keywords are processed.

Filters (exclude): Links containing excluded keywords are not processed.

Please note: The Productsup platform uses exact matches for Link Contains, Filters (include) & Filters (exclude) which means that if you use the value /p/ the Website Crawaler seeks exactly /p/ .

You can use an asterisk as a wildcard character:

- If the value is */p/ it should end with /p/:http://www.test.com/p/.

If the value is /p/* it should start with /p/:/p/123456.

If the value is */p/* it means that /p/ can be anywhere in the string:http://www.test.com/p/123

This last syntax gives you the flexibility to create structures such as */cat/*/p/* that matches :http://www.test.com/cat/123/p/456

Question marks can function as a regular character or as a wildcard for a known number of random characters.

For example:*/???/*/p/* matches: http://www.test.com/cat/123/p/456

User-Agent: Credentials for the user agent.

9d7838ff7b190001a5cd8a824b5b78f7.png

Concurrent Crawlers: Set the number of active crawlers. You can start with a few and increase their number so long as the performance of your website is performance unaffected.

Note: The more crawlers implement, the faster the crawl, but you should balance this with your website's performance.

Retry on Error: Set how many times the crawler should initiate a crawl if the page is unreachable.

Crawler timeout per page (seconds): Set how long the crawler should wait for answers to its requests before aborting the operation.

Max count of pages to crawl: Set a limit on how many pages to crawl. Start with a limit of around 100, and gradually increase the maximum amount of pages to crawl. If your limit is too high, it could slow down processing for your site in Productsup, preventing you from importing and exporting while the Productsup platform waits for the crawler to stop.

Important: Check the Permissions checkbox to authorize Productsup to crawl your website.

1705c80570d6a4e918f51bca709f4866.png

Save changes.

Import data from an RSS feed

To import data from an RSS feed, select Add Data Source in Data Sources .

Search for RSS Feed and set it as the data source.

c4a66bef69ae6cb0b55a7a582dd09018.png

Enter the RSS feed URL and select Save.

Note that if your products exist on multiple pages, you must enter values into the Page Variable and First Page/Last Page Value fields.

For example, if the RSS URL is http://www.yournewsfeed.com/rss/xml?page=1, the page value is page. Alternatively, for http://www.letsfeedit.com/rss/xml?paginated=1: has a paginated page value.

Import data from Google Merchant Center

You can import data from Google Merchant Center to export to other marketing channels.

Please remember:

  • To authorize the Productsup platform to access your Google Merchant Center account. Check Add OAuth authentication to external systems on setting up authorization if you have not already done so.

  • Sites using this source for import data must not also export data to the Google Merchant Center. This scenario creates a loop and generates data conflicts.

To import your Google Merchant Center feed into Productsup select Add Data Source in the Data Sources menu.

Search for Google Merchant Center and set it as the data source type.

495a55d2baa7a047ee0c6ac154470ae1.png

Enter your Merchant Center ID.

d9c1f41be0dd9b9c67b381a349ef8bcb.png

Please note: If you have a multi-client Merchant Center account, enter the ID of the sub-account that stores the data you want to import.

48c8d6fc51ab2cd8e7dea8ac63140c66.png

Select the appropriate authentication and select Save. The Productsup platform pulls data from your Google Merchant Center account on the next import.

Import from Google Merchant Center (Product statuses)

Note: to import from Google Merchant Center, add an authentication first. See Add OAuth authentication to external systems for more information.

In Data Sources, click on Add Data Source.

Select Google Merchant Center Statuses in the dropdown.

1591eaa85aa9579eab7a30508ae9a53b.png

First enter the Merchant Center ID.

d9c1f41be0dd9b9c67b381a349ef8bcb.png

Note: Enter the Merchant ID from the account with data. If you have a multi-client Merchant Center account, enter the ID of the sub account from where Productsup should import the data.

48c8d6fc51ab2cd8e7dea8ac63140c66.png

Select the right Authentication from the dropdown.

In most cases the Product Statuses will be an additional data source. In these cases connect the feed via the ID or corresponding columns.

Finally click on Save Data Source.

724918d91e5c9c4e4aad272b84ebddaa.jpeg

Import data from an existing Google spreadsheet

You can use Google spreadsheets as a Main Feed or an Additional Feed.

In Data Sources, select "Feed/URL" as the data source. To add an existing Google spreadsheet, you must adjust the URL Google provides you.

In this example, the {key} in brackets is a variable and is usually a combination of numbers and letters in the spreadsheet's URL:

https://docs.google.com/spreadsheets/d/{key}/export?format=csv

The ?format=csv parameter makes the Google spreadsheet available as a CSV file. Note that only the first tab in the spreadsheet generates a CSV.

Import specific sheets

If your spreadsheet contains more than one sheet, and you want to import one of them aside from the first tab, you can do this by adding the GID. {gid}.

You can find the GID at the end of the spreadsheet's URL:

https://docs.google.com/spreadsheets/d/{key}/export?format=csv&gid={gid}

Import a range from a spreadsheet

If you want to import a specific area from your Google spreadsheet, you must add an additional parameter. For example: range=A3:C15 You can combine this with the GID parameter if you want to import a specific area of a particular sheet.

https://docs.google.com/spreadsheets/d/{key}/export?format=csv&gid={gid}&range={range}

In the end, your URL should have this format:

https://docs.google.com/spreadsheets/d/1-WthisbAX9wdhTj5gjNjR9rBw10WAvfdfdfdy1o2TiZ20/edit#gid=666000148&range=A3:C15

Important: Set accessibility of the spreadsheet to accessible for anyone with the link. Otherwise, the Productsup platform cannot import the spreadsheet.

How to find your Google spreadsheet key:

The spreadsheet key is a long sequence of characters in the “key=” attribute of the URL. Alternatively, it might be present between the slashes in the URL.

Import data from a shopping platform

If no import feed is available, it is possible to import the product catalog directly from specific shopping platforms and marketplaces.

5ec33433e216a70469fd6d357db4499a.png

Import data from AliExpress

To use AliExpress as your data source:

  • Enter your API Key.

  • Choose the relevant categories for your product data.

  • Select Save and import the feed by selecting Import in the Data Source tab.

Please note: The categories list does not include Home & Garden, Electronic Components & Supplies, and Phones & Telecommunications.

60a2aad024b81ef2c64f3b6276083e83.jpeg

Import from Amazon Marketplace

Use this data source to import your data from the Amazon Marketplace using the Amazon Product Advertising API.

Before starting, you need to register as a Product Advertising API developer with Amazon Associates. There you can create an API Access Key and an Access Secret Key.

Access the API via the Productsup platform

Go to the Data Sources tab, click Add Data Source and select the Amazon Product Advertising API as a source in the dropdown.

35377fb05a47cc4bba250f43f604f9f3.gif

Mandatory Fields

To access the Amazon Product Advertising API via the Productsup platform, you need the following:

  • Your AWS API Key

  • Your AWS API Secret Key

  • Your AWS Associate Tag (Associate ID)

  • The country you registered in

  • The last mandatory field is the category field where you enter the Amazon Search Index.

Refining your product import

If you do not want to download all products, you can refine your request with the following fields:

  • Browse Node: Categories divided into sub-categories.

  • Keywords: Enter keywords to narrow your request to items associated with these keywords.

  • Brands: Enter brand names to narrow your request to items from certain brands.

  • Availability: Filter for available items.

  • Condition: Filter by condition.

  • Minimum Price/Maximum Price: Define a price range for the products imported

Import from the eBay API

You can import your product catalog via the eBay API in IData Sources. This feature is beneficial when you directly connect your shop system and the eBay Marketplace. It also enables you to advertise your products on other marketing channels without creating a master feed.

96c3a88fffd426258ab57772a24b1305.png

You can find the appId and globalId eBay account. The Productsup Platform requires these to access the API and download the catalog.

Add the categoryId of the products you want to import.

Keep in mind: You can only download one category per data source. If you want to download multiple categories, you can add more in Data Sources.

Import data from a user-defined bucket

You may want to combine multiple feeds from sites derived from separate exports into a unified Data Source. You can do this with the "Export to Data Source" feature.

Setup Export and Import

Export into a Bucket

Choose "Export to Data Source" as a destination in the export setup of the single merchant sites and add a name for the bucket.

dd8f704c331438a27fd560d1f077dc38.png

You can define the bucket you want to import by selecting "Setup" - exports with the same setting export to the same bucket. Select the Bucket field to reveal a list of existing buckets. You can choose an existing bucket or enter a new bucket name.

Remember that all feeds set to the same bucket need to have the same structure.

If you also want to export skipped products, activate "Allow skipped rows".

Columns created by an import service such as Group Attributes can also export into the bucket. You can use these columns for other sites without applying the service again. If you do not want these columns exported into the bucket, activate "Remove Passthru Columns".

6149d58866642.png

Click "Save" and export the feed.

Import from a Bucket

Add a new data source in Data Sources in the site you want to import the feed from the bucket. Select "Export to Data Source" as the type.

415105f07d80e9577102667edf93c951.png

All available buckets from your account appear in the dropdown. Choose the one you want to import into the site.

Use additional import sources

Microsoft Azure Blob Storage

You can import data from Azure Blod Storage as follows:

  1. Click on Add Data Source in the Data Sources menu.

  2. Search for Microsoft Azure Blob Storage and select it.

  3. Enter the URL for your blob storage in Container.

  4. Enter the domain in Account Name.

  5. Enter the Access Key in Access Key.

  6. Click on Save.

82fec7648496d26991c4f36b552e70f5.jpeg

Import a local file

You can also import local files. Either drag the file to the white area or browse for the file. Select Upload.

By default, the Productsup platform detects the file form. But you can optionally enter the file format. Select Save all settings.

After you select Save all settings, the Productsup platform imports all data.

Please keep in mind:

  • You can only choose one data source at a time to upload.

  • The Productsup platform automatically creates an FTP server if you import using this option. The file goes to the FTP server. Deleting the File Import Data Source also removes the FTP account.

9faa6755aa7a07734d5fd899211e60a6.jpeg

After the first upload, you have the same setup options as the Feed/URL Data Source.

If you want to replace the Local File, you can either delete it, re-add it, or use the Edit button in the Data Sources setup:

6149d58bbb6ff.jpg

Create a new Google spreadsheet data source

You can create new Google spreadsheets in Data Sourcesdirectly.

If you want to create a spreadsheet without signing into a Google account, you can create a Google spreadsheet with Productsup Google authentication. With this, you can obtain a public link to edit the spreadsheet if you leave the Authenticationdropdown menu blank.

If you want to create a spreadsheet with your Google account, first authorize the Productsup platform to access your Google account in Authentication. If you have not done this already, check Add OAuth authentication to external systems to find out how to grant the Productsup platform access to your Google account.

After granting access, you can select your Google account as an option in the authentication dropdown menu. You can then access this data source in your Google drive.

6149d58ce3ab4.png

Important: If you subsequently delete this data source from the Productsup platform, it automatically moves to the trash in your Google drive. You can only restore this file from your Google Account.

Import data from a PIMPMS system

You can import data from a PIM/PMS using the PIM/PMS option in Data Sources.

6149d58e3729e.png

Import SAP Hybris

Enter the Source URL and your username and password to import SAP Hybris data into the Productsup platform. Note, this import only works if you have SAP Hybris installed on your system.

6149d58f3f6b2.png

Import data from Akeneo

1. Import data with the Akeneo Cloud API Import

Prerequisite: To use this data source, you need Akeneo PIM version 4.0 and more recent, or Serenity version (SAAS version)

1.1 In Akeneo: Configure the API connection

  1. In your Akeneo Instance, go to System.

  2. Go to Connections.

  3. Select Create at the top right.

  4. Enter the destination Label and set Flow Type as the Data Destination.

  5. Make a copy of the following four credentials: Client ID, Secret, Username, and Password. Some of this information displays only once, so make a copy immediately.

  6. In both the Role and Group drop-downs, set proper user permissions.

03846ea8fbee827dd77ed690957e86a8.png

1.2 Add the Akeneo Cloud API Import in Productsup

In your Productsup account:

1. Go to Data Sources.

2. Select + Add data source.

3. Search for Akeneo and add Akeneo Cloud API Import.

4. Enter the Hostname - the URL that hosts your Akeneo instance.

5. Enter the four credentials you received from the Akeneo Connection: Client ID, Secret, Username, and Password.

6. Save these settings, and start an import by selecting Import.

The Productsup platform imports all products. The platform also indicates which Entity Groups and Assets are available in the logs. By default, the Productsup platform does not import Entities or Assets.

6149d591f08c7.png

1.3 Optional: import Entities and Assets

If you wish to add Entities or Assets, you must 1. Switch the button "Import Entities" or "Import Assets" to "ON" 2. In the field below, type in the name of the Entity or Asset you wish to import TIP: You can see which Entities or Assets exist and their names in the Productsup logs during the first import. You can open the Logs panel at any time in Probellsup by clicking on the "bell" icon at the top right.

6149d59313ffa.png

2. Importing from Akeneo using a CSV flat file

Prerequisite: You can only use this data source if you are Akeneo PaaS/Flexibility or Enterprise Edition user.

2.1 Set up feed creation in Akeneo

  1. In your Akeneo account, go to the exports section by selecting this icon:

Figure 1. Akeneo Exports
Akeneo Exports


  1. Click on the "Create Export Profile" button in the top right corner.

Figure 2. Export Profile
Export Profile


  1. Enter the Code and Label and select "Product Export in CSV" as a job.

6149d595a54ca.png
  1. Go to the Global settings tab and define the File path, Decimal separator, Date format, and Number of lines per file for your feed. If you do not want to export all products, you can define this in the Content menu.

6149d596a0d95.png
  1. The file saves on your Akeneo server. To guarantee that we can always import the latest version of your product data, you need to make sure it automatically updates and is available for download. Usually, the best solution is to add a script that pushes every new feed to an FTP server. Once the feed is available to download, you can enter the Source URL and the access credentials in your Akeneo Data Source in Productsup:

Figure 3. Akeneo
Akeneo


Setup Akeneo Advanced File Import

After generating a feed from Akeneo, you can set up Akeneo Advanced File Import in Productsup.

Enter the URL of the host into the Host field and your Username and Password. Set the filename of the product file and the delimiter for the file. This is all the information required for a basic setup. If the file is not in the source folder of the host, a URI is required.

Additionally, you can add the following files:

- Category

- Variant

- Attribute

- Attribute Options

- Family

- Family Variant

f4df50d1e99f6f6c018d08763c68a30e.png

For every filename you add, also set a delimiter. You must add URIs if the locations of the files on the server differ from each other.

Finally, select the locales you want to import.

The import automatically merges the files and creates the necessary variations.

Import data from SAP Product Content Hub (PCH)

SAP Product Content Hub enables customers to create a 360° view of their product data for use in omnichannel commerce. You can onboard product data from multiple source systems. After importing this data into the Productsup platform, you can syndicate it through various sales channels.

Select Add Data Source in the Data Sources menu and search for SAP Product Content. Set it as a data source type.

6149d59a00940.png

Enter the host of your SAP PCH and your Authentication token. Select check credentials to validate your token.

Figure 1. sappchui2
sappchui2


You can now select your Catalogue Versions, the Type Classes, and the Languages you want to import from your SAP system.

Import data from PimCore

With PimCore, you can manage, aggregate, and distribute any digital product data. You can format data for multiple channels and deliver user-centric personalized customer experiences.

Prepare data in your PimCore account for export

To import data from a PimCore account into the Productsup platform, you first need to prepare your data for export from your PimCore account.

In PimCore, do the following to prepare your data for export:

Click on the Settings button on the left-hand menu and select Datahub Config.

Creating one config per category is better than batching several categories into one config if you have multiple categories and category-specific attributes. If multiple categories are present in one config, this could lead to the Productsup platform generating an excessive number of attributes, potentially throttling your import. Note that the Productsup platform cannot manage more than 2000 attributes.

6149d59cc1102.png

Add a Datahub Config, define the general settings and the schema.

6149d59dbec3c.png

In the Security Definition tab, you can choose which documents, assets, and workspaces are available for export.

Set an object for an endpoint Productsup address. This example uses Product Data.

The tab also has a field for an API key. The Productsup platform requires an API key to the PimCore datahub.

6149d59f018b4.png

Prepare your Productsup Account to accept PimCore data.

After preparing your PimCore account, you are ready to set up your Productsup account to receive the data. You can add your URL, endpoint, and API Key as a data source in Data Sources.

6149d5a0320a0.png

Import data through a Basic API request with JSON Response

To import from a paginated URL with JSON response, you can use our Basic API Request with JSON Response Import.

For instance, for the URL: "www.myonlineshop.com/export.json?page=1". The Productsup platform sends a request to every page to import all data.

6149d5a1b79d9.png

Source: Enter the Source URL. This text includes everything before the question mark in the URL.

Parameter: If the URL contains any parameters in addition to the page parameter, add them here.

Username & Password: Add a username and password if authentication is necessary.

Root Node & Variant Node: You can set the Root and Variant nodes if necessary.

Page Variable: Set the page variable, for example: "page."

Next Page Interval: Set the page interval if it is not "page=1, page=2,...".

Bundle Elements: Activate if you want to bundle elements from repeating nodes.

Bundle Delimiter: Set a delimiter to separate bundled elements.

Notifications: Set a notification interval, for instance, every 10 or 100 products.

Import data from Amazon S3

To import a data source from Amazon S3:

  1. Go to Data Sources

  2. Select ADD DATA SOURCE and choose Amazon S3. Confirm by selecting Continue.

  3. Enter your API Key and API Secret for Amazon AWS.

  4. Enter the bucket name in Bucket and the bucket file name in Filename.

  5. Choose your S3 region in Region.

  6. Add a Description (optional).

  7. Select Save at the top of the page in the Data Sources tab.

  8. Select Import to import the data source manually.

6149d5a326b93.png

For information on how to set up an automatic import, check Import dynamic URLs.

Import data from MySQL databases

Introduction

You can pull feed data directly from a database in the Productsup platform.

Prepare your data for export

1. Supported database types

Productsup provides connectors for the following database types: - ODBC connector to connect to every database supporting Open Database Connectivity - MySQL connector to connect to any MySQL database - PostgreSQL connector to connect to any PostgreSQL database - Microsoft SQL Server connector to connect to any MS SQL database.

2. Using SQL queries

With SQL (Structured Query Language), users can access multiple data records with a single command. For example, with a select request:

Table 1 "product_data"

id

product_id

title

type

1

222

book

direct

2

333

table

dropship

3

444

lamp

dropship

Table 2 "product_pricing"

id

product_id

price

1

222

9.99

2

333

69.99

3

444

49.99

Example: Execute the following requests:

select product_data.product_id, product_data.title, product_pricing.price from product_data join product_pricing on product_data.product_id = product_pricing.product_id where product_data.type = 'dropship'

It results in the following output:

product_id

title

price

333

table

69.99

444

lamp

49.99

Elements of the query

  • select - the select command followed by a list of attribute names defines which attributes to include in the result.

  • from - defines the source table(s) for the data.

  • join - use this command when the data source is more than one table.

  • on - lets users define which attributes to connect in the tables.

  • where - specifies the conditions required for a result to appear.

Optimizing the query

You can make queries more concise by using aliases for long table names. You must add these aliases to the "from" part of the query:

select pd.product_id, pd.title, pp.price fromproduct_data pd joinproduct_pricing pp onpd.product_id = pp.product_id where pd.type = 'dropship'

Setting up SQL Data Sources

ODBC Database Import

The Productsup platform can connect to any SQL database with ODBC drivers installed. For PostgreSQL the Productsup platform support "PostgreSQL UNICODE" or "PostgreSQL ANSI" ODBC Drivers. For MS SQL, the Productsup platform supports "ODBC Driver 17 for SQL Server".

16888_hpr__1_.png

Connection String: Your database provider can generate a connection string. It should have the format: Driver={ODBC Driver 17 for SQL Server};Server=mssql.123testing.com;Database=tempdb;.

Username and Password: Your database administrator can also provide these credentials.

-Query: Add a query as described above.

Description: Add a description for your database.

Import MySQL data

The Productsup platform can connect to any MySQL database.

- Hostname: The hostname of your database.

- Port: The port number assigned to your database.

- Username and Password: Your credentials to access the database.

- Database: Name of your database.

- Query: A query in format described

- Charset: Set your database character set, if known.

- Description: Add a description for your database.

Import PostgreSQL data

The Productsup platform can connect to any PostgreSQL database.

6149d5a71bdaa.png
  • Driver: Select the driver of your PostgreSQL database, either "PostgreSQL UNICODE" or "PostgreSQL ANSI."

  • Hostname: The hostname of your database.

  • Port: The port number assigned to your database.

  • Database Name: Name of your database.

  • Username and Password: Your credentials to access the database.

  • Query: A query in the appropriate format.

  • Description: Add a description for the database.

The Productsup platform can connect to any Microsoft SQL Server database.

6149d5a86e1a2.png
  • Hostname: The hostname of your database.

  • Port: The port number assigned to the database.

  • Database Name: The name of your database.

  • Username and Password: Your credentials to access the database.

  • Query: A query in the appropriate format.

  • Description: Add a description for your database.

Import data from IceCat

To import data from the IceCat catalog, select Add Data Source in Data Sources. Search for IceCat and select it as the data source type.

6149d5a9f3e6a.png

Enter your Username and Password. Enter the Supplier ID(s) for the supplier containing the product information. Add the Categories you want to download and a link to the Open IceCat index file. Select your Language and, if desired, add a Description.

Import data with a basic SOAP API

You can set up a basic SOAP API as a data source as follows:

6149d5acdabe8.png

Enter these details:

  • WSDL URL

  • The root node of the Response XML

  • An Endpoint

  • Request parameters

  • Authentication (if required)

Select Save, and the Productsup Platform pulls data from this source on the next manual or scheduled import.

Import data from the Productsup API

The Productsup API offers a dynamic method to import product data.

Add the Productsup API as a data source

Go to Data Sources and filter for Productsup Platform API. Select the Add button.

6149d5ae5e98b.png

Set up the Productsup API as a data source

6149d5af9e80b.png

For the Productsup platform to accept the Productsup API as a data source, you must configure the following:

- Product Update Mode: You can set this to either "update" or "replace." If left empty, "replace" is the default. If set to replace, your updates should contain complete information. If set to update, you only need to include the attributes you want to update.

Import process report email address: The email address you enter in this field receives notifications for each import. The email contains a log of the imported batch IDs.

Description: Change if desired.

Import product data from Amazon MWS

Note, this is a different procedure from importing orders from Amazon MWS. If you need help with this, check this document.

If your products already exist on Seller Central, you can import them into the Productsup platform using Amazon MWS as a data source.

Follow these steps to import your products:

  1. Go to Authentication from your site's main menu. Select ADD AUTHENTICATION.

  2. In Type, select Amazon Authentication (BETA version by Amazon). You can customize the authentication description in Name. Now, select Next.

  3. In Region, select the region for Productsup to manage your inventory.

  4. The Productsup platform directs you to Amazon for authentication. Enter your credentials to connect your Productsup exports to Amazon.

  5. Authenticate our Developer ID to submit report requests on their behalf. Contact your Account Manager to obtain this authentication.

  6. Import the feed, and your products should appear in Data View.

Import data from Google Cloud Storage

Google Cloud Storage Data Source allows users to generate a CSV file from their Google Cloud Storage.

6149d5b1b4c77.png
  • Service Account Key: Enter a Service Account Key in JSON format.

  • Bucket: Enter the name of the target bucket in Google Cloud Storage.

  • Object: Enter the name of the target object file.

Note: Currently, Data Source only generates CSV files.

If you merge your main data feed with additional data information via Google Cloud Storage, the import process and merging can take a great deal of time if there is a large data set. To speed this process up, you can set up a Site-Tag that contains the information found as an object in the bucket in the site settings. This setting enables the site to look only for relevant information in the Google Cloud Storage file.

Example: You want your site "US_tablet-case" to import only the tablet cases from your Google cloud file.

  • Tag your site with product_type: tablet-case in the site settings.

  • In the Google Storage field Object, enter the object name in the bucket. In this case, tablet-case-product_info.csv. The site now only imports and merges the relevant information.

If you want to set up multiple sites with a changing set on product_types and product information for each site, you can automate this as the data source. You can also enable support for Twig and Site-Tag variables by default. The site tags can be set up automatically via the Productsup Platform API. The twig automatically pulls in the correct data based on the site-tag from Google Cloud Storage with the API enabled.

Import data from Square POS

Introduction

It is easy to export all your Square POS data to the Productsup platform.

Set up your Square POS account

Log into your Square account and go to Square Applications.

6149d5b5d2f01.png

Click on the + icon to add a new application.

6149d5b6e353c.png

Choose a name and select save.

6149d5b7eadf3.png

Productsup is now a valid application.

6149d5b910d5f.png

Select Open and go to the Production tab. Select Show and copy the token.

Prepare Data Sources to accept Square POS data

Go to Data Sources and filter for Square.

6149d5b3976fd.png

Select the Add button. You can rename the data source or leave the default title.

6149d5b49d1d8.png

Import data from iZettle POS

To import product data from iZettle:

Select Add Data Source in the Data Sources menu.

Search for iZettle and select it as a data source type.

6149d5ba6c4cf.png

Add your authentication credentials for iZettle and add a description if desired.

Select Save.

Import your Google Delivery Zones data

You may need to import Google Shopping Delivery Zones data if you use Google Regional Inventory: Delivery Zones Export.

If the delivery zones are sent to the Google Merchant Center by more than one source, download all delivery zones from the Merchant Center before importing the delivery zones.

Add the Google Deliver Zones data source

Go to Data Sources and select Add Data Source. Filter for Google Shopping Delivery Zones and select Add. You can add an alternative name for the source. Select Next.

6149d5bbce77f.png

Select the appropriate authentication from the dropdown, or create one if necessary.

Add Merchant ID and Account ID. Select save.

6149d5bccecd4.png