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
Example: Two Main Feeds
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.
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.
Import data from a shop system
Introduction
It is possible to import the product data directly from shop systems.
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:
In Data Services, add the following information:
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.
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.
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.
Woocommerce
In Woocommerce set up API credentials as follows:
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/productsShopify:
https://api_key:api_password@example-domain.myshopify.com/admin/products.jsonWoocommerce:
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.
Import data from a PIMPMS system
You can import data from a PIM/PMS using the PIM/PMS option in Data Sources.
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
In your Akeneo Instance, go to System.
Go to Connections.
Select Create at the top right.
Enter the destination Label and set Flow Type as the Data Destination.
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.
In both the Role and Group drop-downs, set proper user permissions.
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.
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.
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
In your Akeneo account, go to the exports section by selecting this icon:
Click on the "Create Export Profile" button in the top right corner.
Enter the Code and Label and select "Product Export in CSV" as a job.
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.
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:
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.
Add a Datahub Config, define the general settings and the schema.
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.
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.
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.
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 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".
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.
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.
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 with a basic SOAP API
You can set up a basic SOAP API as a data source as follows:
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.
Set up the Productsup API as a data source
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:
Go to Authentication from your site's main menu. Select ADD AUTHENTICATION.
In Type, select Amazon Authentication (BETA version by Amazon). You can customize the authentication description in Name. Now, select Next.
In Region, select the region for Productsup to manage your inventory.
The Productsup platform directs you to Amazon for authentication. Enter your credentials to connect your Productsup exports to Amazon.
Authenticate our Developer ID to submit report requests on their behalf. Contact your Account Manager to obtain this authentication.
Import the feed, and your products should appear in Data View.
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.
Click on the + icon to add a new application.
Choose a name and select save.
Productsup is now a valid application.
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.
Select the Add button. You can rename the data source or leave the default title.
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.
Add your authentication credentials for iZettle and add a description if desired.
Select Save.