Build your exports from scratch
Manually create an export template in Add Exports in Productsup.
Introduction
Build exports from scratch using a blank export if existing export templates don't suit your needs. Blank export is a blank canvas that you can customize as you need.
There are four (4) types of blank exports in Productsup:
Blank Export (empty) – This type of blank export lets you manually create a custom set of columns in the Export stage of Dataflow to meet the requirements of the desired export channel. See Set up Blank Export (empty) or Blank Export (with ID) for more information.
Use Blank Export (empty) in the following cases:
To create custom exports, test your export, or use them in reports.
To create an item setup sheet. See Manually create an export template and placeholder setup sheet for more information.
To download a feed with more than 10,000 products. See Download more than 10,000 products for more information.
Blank Export (with ID) – This type of blank export is similar to Blank Export (empty) but has the ID column pre-defined as a mandatory column in the Export stage in Dataflow. See Set up Blank Export (empty) or Blank Export (with ID) for more information.
Delta Blank Export – This type of blank export lets you work with delta logic and delta files. The most popular use case for Delta Blank Export involves exporting only new, changed, and removed products to your export channels without exporting products with unchanged data. Delta logic reduces transport time and data volume for big feeds requiring few updates. See Set up Delta Blank Export for more information.
Export2Datasource Blank – This type of blank export lets you compile data from different sites within one account into a single bucket and use this bucket as a data source in another data-accumulating site. See Set up Export2Datasource Blank for more information.
Note
There are no analyzer tests for these exports.
Add a blank export
To add one of the blank export to your site, take the following steps:
Go to Exports from your site's main menu.
Select ADD EXPORT.
Select the necessary blank export in the gray banner under the search field.
Go back to Exports to see and select your blank export in the Export name column to set it up.
Set up Blank Export (empty) or Blank Export (with ID)
Blank Export (empty) and Blank Export (with ID) let you create custom templates if none of the ready-made templates fits your needs. These templates are blank spreadsheets where you can manually add and map the desired columns in Dataflow.
The process of setting up Blank Export (empty) and Blank Export (with ID) is similar.
After you have added your blank export on the Add Exports page, you need to set it up. For that, take the following steps:
Go to Dataflow from the site's main menu and select your blank export from the channels drop-down menu in the upper ribbon.
Map the Intermediate columns to the Export columns using Drop or Click to add new field. Drag a connection from a node of a desired column in the Intermediate stage to this button.
Note
The ID column is the only mandatory column in the Export stage for Blank Export (with ID) in Dataflow. But you still have to connect it with a corresponding column of the Intermediate stage.
Go to Exports, find your blank export in the list of exports, and change Status from Inactive to Active.
Select your blank export's name in the Export name column.
Select the Edit icon next to the export's name if you want to rename the export.
Select Add Destination in the Destinations section and choose a destination from the drop-down menu. Select Save.
Select Export this export at the top-right corner of the page. Alternatively, the platform exports the file at the next scheduled run.
Set up Delta Blank Export
When you work with extensive data feeds, data processing in the platform may take a long time. With the help of Delta Blank Export, which uses delta logic, you can send only updated data.
Delta is a way of storing or transmitting data in the form of differences, called deltas, rather than complete files. With this logic, the platform doesn't export unchanged products, which allows it to reduce transport time and data volume for big feeds.
The platform takes the product identifier, which can be ID, GTIN, variant ID, etc., to identify each product and compare the product's updated data to its data from the previous run. The platform generates up to four (4) delta files, depending on the data changes:
New – These items are new to the feed.
Changed – These items have been in the feed before, but the data has changed.
Deleted – These items aren't in the feed anymore because of skip rules or deleting.
Unchanged – These items have been in the feed before and haven't changed.
Add Delta Blank Export in the following cases:
If you don't expect your product data to change frequently.
If your target export channel requires you to export your data feed in delta files due to technical requirements on their side.
Note
Apart from the custom Delta Blank Export, several partner-specific delta exports have similar features. For example, Salesforce Commerce Cloud B2C: Inventory (Delta) or Facebook Dynamic Ads (Delta Upload). If you need support exploring your optimal solution, contact your Customer Success Manager or support@productsup.com.
Configure Delta Blank Export
To set up your Delta Blank Export, take the following steps:
Add Delta Blank Export. See Add a blank export for more information.
Go to Dataflow from the site's main menu and select your Delta Blank Export from the channels drop-down menu in the upper ribbon.
Map the Intermediate columns to the Export columns using Drop or Click to add new field. Drag a connection from a node of a desired column in the Intermediate stage to this button.
Note
The export stage already has the ID column, but you still have to connect it with a corresponding column of the Intermediate stage.
Go to Exports, search for Delta Blank Export, and change the Status from Inactive to Active.
Select Delta Blank Export in the Export name column.
Select the Edit icon next to the export's name if you want to rename the export.
Select Add Destination in the Destinations section and choose a destination from the drop-down menu. Select Save.
Some export destinations, for example, Productsup Server, may automatically create a file in the Files section. You don't need this file for Delta Blank Export. If you see an automatically created file, select Setup next to the file and then select Delete.
Select Update Files in the Delta Files section. A pop-up area displays four delta files: unchanged, new, modified, and deleted. Modify the file names and extensions as needed.
Note
If the pre-configured extension of the delta files doesn't match your destination requirements, contact us at support@productsup.com.
Toggle Add Site ID to Delta Filenames to On if your destination system receives delta files from multiple sites or systems. Enabling this option appends the site ID to the filenames to let you distinguish between delta files from different sites.
Select Save in the Delta Files pop-up.
Select Export this export at the top-right corner of the page. Alternatively, the platform exports the file at the next scheduled run.
Tip
After each export run, you can download any delta file in the Filename section at the bottom of the export setup page.
Generate empty delta files
You may want the platform to generate files with deleted and new products, even if such files are empty. It is necessary if your destination system or target export channel always expects to have four files with every export run. Otherwise, your system might ingest files from different runs, which can cause ID conflict issues and product duplicates.
To enable the generation of empty files, follow the steps:
Go to Exports and search for Delta Blank Export.
Select Delta Blank Export in the Export name column.
Go to the Settings tab.
Scroll down and toggle Allow empty files (0 products) from Off to On.
Note
Your target export channel or destination settings must also allow empty files. They may discard these empty files if they interpret them as obsolete or unchanged.
Check your Delta Blank Export history
Go to Exports from your site's main menu.
Go to the Export history tab.
Ensure the Show delta file changes option is active and view the export history.
Set up Export2Datasource Blank
Export2Datasource Blank lets you compile data from different sites within one account into one bucket and use this bucket as a data source in another data-accumulating site.
 |
For example, you run a marketplace and, in the Productsup platform, you have hundreds of sites exporting your separate product feeds to the designated Google Merchant Centers. In this case, you may want a site that combines these different feeds into one main feed and, for example, exports this feed to price comparison channels, Facebook, or other systems. If you did it manually, you would have to create exports in each site, export them to the Productsup Server, and then add them as a data source in one data-accumulating site. Instead, you can use the Export2Datasource Blank template and export all your separate feeds into a bucket. Later, you can use this bucket as a single import source.
Note
Contact support@productsup.com if you want to use this feature. Since it's an advanced tool, you may need assistance with the initial setup.
Prerequisites
To be able to import from buckets, your Productsup account should meet the following requirements:
All sites from which you want to send data to the same bucket should have Export2Datasource Blank with the same bucket name. See Configure Export2Datasource Blank to learn how to add Export2Datasource Blank. You can create a copy of the export channel if you plan to use it multiple times without starting from scratch. See Copy the export channel for more information.
If you have several buckets in your account, each should have a unique name. Otherwise, the platform can't distinguish to which bucket it should send the data.
All sites that send data to the same bucket should have feeds with the same structure.
Configure Export2Datasource Blank
To set up Export2Datasource Blank, take the following steps:
Add Export2Datasource Blank. See Add a blank export for more information.
Go to Dataflow from the site's main menu and select your Export2Datasource Blank template from the channels drop-down menu in the upper ribbon.
Map the Intermediate columns to the Export columns using Drop or Click to add new field. Drag a connection from a node of a desired column in the Intermediate stage to this button.
Note
The ID column is the only mandatory column in the Export stage for Export2Datasource Blank in Dataflow. But you still have to connect it with a corresponding column of the Intermediate stage.
Go to Exports, search for Export2Datasource Blank, and change Status from Inactive to Active.
Select Export2Datasource Blank in the Export name column.
Select the Edit icon next to the export's name if you want to rename the export.
Select Add Destination in the Destinations section and choose the Export to Data Source destination from the drop-down menu.
On the destination setup page, add a name in the Bucket field.
Important
You can't choose an already-created bucket from this field. If you want to send your data to an existing bucket, you must manually enter the existing bucket name. The field is case-sensitive.
To export skipped products, switch Allow skipped rows to On.
You can export columns created by a data service to the bucket and use these columns for other sites without applying the service again. If you don't want to export these columns to the bucket, switch Remove Passthru Columns to On.
Switch Prevent Empty Upload to On to avoid exporting files without data.
Turn on the destination by switching Active to On.
Select Save.
Select Export this export at the top-right corner of the page. Alternatively, the platform exports the file at the next scheduled run.
Note
Export to Data Source is a destination and not a file format. As a result, you can't edit file settings, such as Filename, Product limit, Sorting actions, and Product count.
Import data from the bucket
To import data from a bucket into a data-accumulating site, take the following steps:
Go to Data Sources from the site's main menu and select ADD DATA SOURCE.
Search for Export to Data Source and select Add. Give it a custom name as desired and select Continue.
Select a necessary bucket from the drop-down menu.
Select Save.