Product Identifiers Batchjob
You can start the product details job from the bulk actions menu where you will find it under the products batch jobs.
A link to a Google Sheets Template for doing a price batch can be found here: Link to spreadsheet
Below we will explain step by step how to do a product details, what to consider for each step and some tips and tricks.
To start the batch job click on start batch, on the product details update tile. On Start Batch, this will open the bulk action.
The batch job reference is pre-filled with the batch job name, date and time. You can change this if you want.
In the second step you can choose how you want to provide the data of your batchjob. For this we have 3 options:
- Existing dataset
- CSV integration
Every time you create a spreadsheet in Afosto you have to specify a reference, by doing this you create a so called Data Set that you can use later in another batchjob. By doing this you don't have to give us the same data every time you create a batch job.
By choosing an existing data set you can choose one of the previously created data sets from your Afosto account.
After choosing an existing dataset, you will get an overview of the data in that dataset.
If you choose the spreadsheet option you can enter or copy-paste the data into a spreadsheet form. This also creates a dataset that you can then open through the existing dataset function.
After filling out this spreadsheet and clicking the next step you will get an overview of the newly created data set.
When choosing the CSV integration you can either choose a previously created CSV integration or create a new CSV integration by clicking on + new csv integration
Creating a new CSV integration allows you to select it later for different batch jobs across the platform.
Enter the name of the new CSV integration. It is wise to enter a name that you can recognize later by creating a description of the data in the CSV. For example: Product prices - [brand x] - [date].
Here you can choose between pasting a url or uploading a CSV file. The url must be publicly available.
This setting allows you to choose the separator of the CSV file you chose in the previous step. The available options are: Tab, Comma, Semicolon, Space
After adding a new or choosing an existing CSV integration, you will get an overview of the data within the CSV file.
In the column selection step, you can assign the columns of the data set from the previous step to the corresponding fields needed for the selected batch job.
After you have assigned the columns to the fields of the batch job and clicked next, the batch will be validated by the system. Once validated you can run the batch job and the product details will be updated according to the data provided!