Additional Sources

There may be times where you want to add in more product data that is not accessible from Shopify or your data feed. While you can do so by adding a new custom column, the process can get tedious when you want to add more than a few values across all of your products. This is where additional sources come in.

With additional sources, you can import spreadsheets of information to Marpipe, matching values with products that have been uploaded by your source feed.

Your additional source must contain a minimum of two columns: a key column and a column of values you'd like to use per key. Keys can be the information of any column present in your source feed. This includes (but not limited to)

The rest of your columns can be made up of the values you'd like to use when a product matches that key. You can include as many columns as you'd like of additional information, but only one key is allowed per additional source

I would like to add a specific testimonial per product in my feed

The key I've chosen is item_group_id, so my additional source may look like this:

Because two items in my feed match the item_group_id 8441, they will both receive that testimonial.

Additional sources can be uploaded in one of two ways:

Once your additional source is created, you can import it to Marpipe. Go to Data Sources on the left nav bar. Underneath your main source, you'll see an option for New Data Source

From here, you can name your additional source and input the URL or upload your CSV file. If inputting a URL, make you'll need to specify the format the data source is in from the dropdown

Next, select the column from the left dropdown that you'd like to designate as your key, and select a field from your source feed you'd like to compare the key against. For this example, I'll match my additional source column shopify_product_id to the field item_group_id in Marpipe

Lastly, toggle on which columns you'd like to import to Marpipe as an available internal feed. You can also rename your column when importing if the original column name is already in use.

You can use additional sources to map additional images per product or product groups as well. This allows you to bulk upload custom images that would not normally be accessible through your primary data source.

To upload new image fields through additional sources, you'll need to add accessible image URLs in your spreadsheet. The image URLs must link directly to the image itself, and cannot be hidden behind a login or username/password. Embedded images cannot be read.

Once your image URLs have been added to your spreadsheet and mapped to their designated key, upload the additional source as normal above, except this time, change your Field type to image for the designated columns before importing.