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.
| Column header | Description | Column header filter |
|---|---|---|
| ID | The unique identification number assigned to the import operation for reference and tracking purposes. | Live search |
| Created on | The date and time when the import was created. | |
| Status |
The current status of the import operation. It can be one of the following: New: The file has been uploaded but not yet processed. In progress: The import is currently underway. Done: The import has been completed successfully. No products: The import file contains no valid data. |
Dropdown list |
| Number of products | The total number of rows with product data included in the import file. | Live search |
| Number of rows with errors | The number of rows with product data in the import file that contain errors. | Live search |
| Number of imported rows | The number of rows with product data that were successfully imported. | Live search |
| Start date | The date and time when the import operation was initiated. | |
| End date | The date and time when the import operation was completed. | |
| Updated | The date and time when the last change or modification was made to the import settings or file. | |
| Type |
The type of import operation performed. It can be one of the following: Bulk edit: An import operation created manually through “Bulk edit” on the “Product costs” or “Indirect costs” pages. Auto import: An automatic import operation scheduled on the “Auto import product settings” page. Manual import: An import operation created manually by uploading a file on the “Import product settings” page. |
Dropdown list |
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.