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. Product identifiers batchjob

Google Sheets Template

A link to a Google Sheets Template for doing a price batch can be found here: Link to spreadsheet

Product Details Bulk Action Settings

Below we will explain step by step how to do a product details, what to consider for each step and some tips and tricks.

1. Starting the bulk action

To start the batch job click on start batch, on the product details update tile. On Start Batch, this will open the bulk action.

2. Enter Reference

The batch job reference is pre-filled with the batch job name, date and time. You can change this if you want.

3. Select the data source

In the second step you can choose how you want to provide the data of your batchjob. For this we have 3 options:

  1. Existing dataset
  2. Spreadsheet
  3. CSV integration

Batchjob step 2 data

Existing dataset

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.

Spreadsheet

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.

CSV integration

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 CSV integration Afosto Batchjobs

New CSV integration

Creating a new CSV integration allows you to select it later for different batch jobs across the platform.

Name

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].

Setting up CSV integration

Here you can choose between pasting a url or uploading a CSV file. The url must be publicly available.

Choose separator

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.

Column selection

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.

Validation

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!