The “Import product settings” page presents a table with a list of all import and bulk edit operations initiated by the users under your account on “Product costs”, “Import product settings”, or “Auto import product settings” pages. It also allows you to perform a manual import of product settings to the Business Analytics “Product costs” page from external sources.

The “Import product settings” page can be accessed in two ways:

• SELLERLOGIC Homepage > Business Analytics | Import
• Business Analytics navigation bar > Import / Export > Import

Table fields

Below is a table listing all fields available on the "Import product settings" page, along with their respective descriptions.

Perform manual import

To perform the manual import of product settings data to Business Analytics, follow these steps:

Step 1: Download the import template on your PC, by selecting the “Download template” button with the down-arrow icon at the top left.

Step 2: Open the downloaded import template on your PC using a spreadsheet program. Review the columns and headers, which represent the data fields for the product settings on each of the template tabs:

• “Data definitions” includes the instructions for filling out the columns of the “Template” tab;
• “Template” is the main tab to be filled out with the data you want to import;
• “Example” provides examples of values for each column;
• “Valid values” provides the values offered in the dropdown lists of the “Template” tab columns.

Step 3: Fill out the “Template” tab with the data you want to import to Business Analytics. Ensure that you follow the required format and guidelines specified on the “Data definitions” tab.

Step 4: After you have filled out the import template with the necessary data, save the file in the required file format: Tab-delimited text (TSV) or Semicolon-delimited value (CSV).

Step 5: Return to the "Import product settings" page and select the “Upload file” button with the up-arrow icon at the top left. Select the previously saved import file from your PC by clicking the “Choose file” button. After attaching the file, click “Upload”.

Note: If the import file is of the wrong file format or has the required fields missing, the relevant warning message appears. Review the message and make the necessary corrections to your import file. Repeat the upload process for the corrected import file.

Step 6: Once the import is launched, a new entry will appear in the table labeled as "Manual import".

Info: You may delete the import file from the system only while the status of the import is “New” by clicking the trash bin icon at the beginning of the relevant table line.

Step 7: If there are any errors during the import operation, the system will indicate it with an error icon at the beginning of the relevant line. Click the “Show errors” button with the error icon to open the “Product import errors” modal form with the detailed error information. Review the error messages to determine what product data have not been imported.

By following these steps, you can import product settings data to Business Analytics using the provided import template. Successfully imported product settings data will be available on the “Product costs” page and the values for the product costs as well as the “Synchronization with Repricer” status will be updated for all products included in the import file creating new cost periods.

Note: If the import file provides updates both on cost values and “Synchronization with Repricer” status, then the imported product cost data will be reflected in the newly created period until the system updates the data from Repricer. After that, the new period will be created and the imported period will remain in history.

Tip: To download your import file, click the "Download" button located at the beginning of the relevant line. You can download your import files until the corresponding entry is removed from the table. Note that this table can hold a maximum of 10 import operations and 10 "Bulk edit" operation entries simultaneously. When, for example, a new import operation is initiated, exceeding the limit of 10 import entries, the oldest entry will be automatically removed from the table and will no longer be available for download.

Review errors

If the error icon is shown for an import entry, click it to review the data that was not imported during the operation.

The "Product import errors" form presents detailed information about the errors that occurred during the product manual or auto import operation. It allows you to identify the specific errors that prevented certain products from being imported.

• Field: The name of the column with the error;
• Error: The type of the error;
• Total number of lines: The total amount of rows (products) with this type of error;
• First 100 lines: The row number in the import file with this type of error from among the first 100 rows of the import file.

Table options

Each column header provides “Ascending” and “Descending” sorting options as well as individual filtering of data upon a click on the column header filters as provided in the table above.

The “Table settings” and “Table content” buttons, located at the lower right of the page, enable you to customize the view and content of the page table. The “Table content” modal form allows you to manage the columns of the table, by changing their respective order or visibility status. For more information, see SELLERLOGIC | Common service features.

The “Export results” button, represented as an up arrow icon at the top right of the page, enables the export of all fields with data from the first table page. By clicking this button, you can export up to 100 table rows in CSV, XLS, or XLSX file formats.