Let us understand how to export data from a Catalog.
To export data from a catalog:
Open the catalog and click the Quick Action
icon on the catalog action bar as shown below. Click Export Catalog.
OR
Go to Catalog > All Catalogs and click the Export Catalog icon on the catalog from which the data is to be exported as shown below.
The following screen appears.
NOTE | The catalog name and hierarchy is automatically selected if the export option is invoked directly from the catalog as shown below. |
Here, a list of all the export file types supported is displayed in a card format. By default, All export types are displayed. Depending on the export file type to be generated, you can further select the tabs to select the particular export type as shown below.
Currently, 15 export formats are supported which are categorized as follows:
PCC Standard Type – Click this to view the PCC standard formats, that is, BIF, standard horizontal and vertical files. The data can then be exported by selecting the required file type.
Ecommerce Platform – Click this to view the various ecommerce platforms to which the data can be synced from PCC. The data can then be synced to the required platform.
Industry Standard – Click this to view the customized xml created for the exchange of catalog data.
Specific Organizations - Click this to view and sync the data from PCC to the format supported by organizations listed here. The users can export their data directly in a format used by below mentioned organizations to ingest their data into the system directly.
Alternatively, you can also search the file type and based on the keywords entered, the matching file types will be displayed.
A View Details
icon is present in each of the file types. This shows details about the file type. For example, if you click this icon for Horizontal CSV file type, the following is displayed.
An overview of the horizontal CSV file is provided along with a link to start the export process.
Also, you can download a sample file to get an idea of how each file generated will be in terms of the details added in it. Click Download Sample File and the file will be downloaded based on the file type selected.
Depending on the format in which the file is to be exported, click the Export Catalog
icon present in the file type displayed. Let us export the data in horizontal excel format as shown below.
The following screen appears.
Figure 307: Export data from catalog
NOTE | The file type is automatically selected while selecting the export option and is mentioned in the screen name as well. In this case, the file type is Standard Horizontal Excel. |
Enter the Export Name for the file to be saved.
By default, all nodes present in the catalog will be exported. However, if you do not want to export the entire data, you can select the nodes and export only specific data from the selected nodes.
Select SKUs in selected nodes to select the nodes (that is, the data) from the catalog to be exported. Select the nodes from the list as shown below.
Figure 308: Select nodes to be exported
Select SKUs using saved condition and select the saved condition under Select a Saved Condition dropdown. Select the nodes from the list as shown below.
NOTE | There is another option to export the selected nodes. You can also right-click the Node / multiple nodes directly from the Taxonomy tree as shown below and then click Export Node. |
Figure 309: Right-click node to be exported
The following screen appears.
Figure 310: Node selected to be exported
Depending on the file type selected, the node selected is populated directly.
NOTE | The Entities To Be Exported will change depending on the file type selected. In this case, since horizontal excel is selected, only SKUs will be exported. However, if a vertical file is selected, multiple entities will be exported. Also, Field Delimiter, if required will auto populate based on the file type. |
The following table lists the entities that can be exported based on the file type selected.
Table 34: List of file types and the entities allowed
File Type | Required | Entities to be Exported |
|---|---|---|
BIF | None | By default, the following is selected:
You can deselect the entities not required, if any. |
Standard Horizontal Excel | None | By default, only SKU is selected. |
muCSV | Field Delimiter – Select the delimiter from the list of field delimiters as shown below
| By default, only SKU is selected. |
Standard Vertical Delimited | Field Delimiter – Select the delimiter from the list of field delimiters. | By default, the following is selected:
You can deselect the entities not required, if any. |
Magento 2 | Select the Magento Store Name from the drop-down list to which the data should be synced as shown below.
| By default, only SKU is selected. |
Magento 2 Sync | Select the Magento Store Name from the drop-down list to which the data should be synced as shown below.
| By default, only SKU is selected. |
WooCommerce Sync | Select the WooCommerce Store Name from the drop-down list to which the data should be synced as shown below.
| By default, only SKU is selected. |
BigCommerce Sync | Select the BigCommerce Store Name from the drop-down list to which the data should be synced as shown below.
| By default, only SKU is selected. |
Shopify | Select the Shopify Store Name from the drop-down list to which the data should be synced as shown below.
| By default, only SKU is selected. |
Grainger | Select the Export Template created for the catalog from the drop-down list and upload the relevant file to which the data should be exported as shown below.
Refer to section Exporting Data using the Export Template for more details. | By default, the SKU attributes mapped will be exported in the file uploaded. |
Amazon | Select the Amazon Store Name from the drop-down list to which the data should be synced as shown below.
| By default, only SKU is selected. |
Oro Commerce | Select the Oro Commerce Store Name from the drop-down list to which the data should be synced as shown below.
| By default, only SKU is selected. |
BMECat | Select the BMECat version from the drop-down list.
| By default, all the entities will be selected. |
Fastenal | Select the Export Template created for the catalog from the drop-down list and upload the relevant file to which the data should be exported as shown below.
| By default, all the entities will be selected. |
Stibo Step XML | Select the Export Template created for the catalog from the drop-down list and upload the relevant file to which the data should be exported as shown below.
| By default, all the entities will be selected. |
Based on the file type selected, the data will be exported in the selected format.
Click Export and the export process is initiated and the details are updated in the Exports page as described in section Viewing the Export File .