Bulk Product Import in to Web departments and Sub departments

Products can be imported in to web departments and sub departments in two ways.

1. Search from database

2. Upload a csv

To access a script, you need to navigate to the Web Department/Sub Department Maintenance page and edit the relevant department and sub-department.

 Once you've done that, you'll see an "Add a Product" button on the right-hand side of the maintenance page. Clicking on this button will redirect you to the bulk product import page. 

Search from Database:

If you select "Search from Database," you'll be taken to a screen where you can search for products using three filters: department, sub-department, and keyword.

 Once you've searched for a product, a list of all relevant products will appear based on your search criteria. You can select the products you want to import and click the "Import" button, and they will be added to the selected departments.

 You can see the imported products on the table below, where you can delete or export them, and change their ranking using the maintenance page. 

Upload a csv

Alternatively, if you choose "Upload a CSV," you'll be taken to a screen where you can upload a CSV file. The rules for the file are listed on the top right-hand side card, and you can download an empty format file from there.

Drag and drop the CSV file onto the "Browse" button on the top left card, which will also display the web department and sub-department names where the products will be imported. 

There are two buttons on this card: "Validate" and "Validate and Import." 

The "Validate" button checks the file for errors, while the "Validate and Import" button not only validates the file but also imports the products if there are no errors. 

After importing, you can view the products on the table given below.

There are two types of errors that may occur during the importing process. 

A validation error occurs when there is an issue with the file during validation, usually because the data is not in line with the provided rules. 

An import error occurs when the file is validated correctly but there is an issue during the import process, usually because the product is already present in the web department/sub-department and is being added again from the CSV.

• Related Articles

• Product Amendment Import/Export

  Product Amendment Import/Export The import / export utility has been created to allow for easy updating of a products descriptions, department/sub department and min/max level, loyalty redemptions, bar form till . The program sits under Stock: Style ...

• Bulk Price Changes

  First go to the Pricing tab from the main menu and select Bulk Price Changes. You can change the price against a specific branch or choose all branches. Select a date when the changes will become effective. Choose today’s date to do it immediately. ...

• Creating New Web Departments/Sub Departments

  Within Customer Order Setup - Web Department/Sub department Maintenance Create New Web Department Add in the Department Name in the first two fields and add the date for the department to show (today) Click create new department If you require ...

• Extracting a list of Product Web Descriptions

  This report can be useful if you need to review all of your product web descriptions in a single spreadsheet or if you need to send a list of descriptions to be translated to a different language. To run the Catalogue Extract go to the Reporting Menu ...

• Use Customer Group Import Utility

  Import using a CSV with Client Ref, Name and Email Go to Customer Database > Customer Group Import Utility Click on the Import Season Ticket Holder tab. NOTE: The CSV File needs to have 3 columns and in the following order. The Name column can be ...