Shipping Matrix Price Updates

Running the generator

1. Open the generator directory. You should see 3 folders and 2 files, as so:

   

2. Run the Parent_Shipping_Conversion.exe file by double clicking.

   Note

   The exe file is a Windows executable, so you will need to use a Windows machine to run it.

3. This will populate the required folders either creating or replacing existing files.

4. Open the ‘Rates’ sheet and edit the rates for the shipping category.

Tip

It’s a good idea to check the values on your import sheets appear as expected before attempting to upload.

Generator Sheets Explained

The ‘Rates’, ‘2nd Parcel’ and ‘Delivery Times’ sheets are reffered to as the Matrix tables.

Rates

This sheet is used to edit the rates for the shipping category. the tables x axis is the zone code, the y axis is the chipping category - linked to a constructor sheet of the same name.

2nd Parcel

This sheet is used to set the 2nd parcel charge for the shipping category. It can be either a fixed price or a percentage as indicated by the Neto config for the associated shipping category.

Delivery Times

This sheet is used to set the maximum delivery time for the shipping category. It is submitted as a range in Google Merchant Center, but is communicated as a single value in Neto. As a result the we use a nominal default for the minimum value.

Zones

This sheet is used to set the zone codes and the carrier for the shipping category. It also allows the constructor sheets to reference the zone codes.

Constructor sheets

The constructor sheets are used to build the export. The Sheets are important but don’t require editing for an update to pricing. The Contstructor sheets are names for their respective shipping category and allow for the correct structure for imports.

They should be hidden from the user and only be used for the generator. Learn more about the constructor sheets in the generator docs.

Updating the rates table

1. Open the ‘Shipping Update.xlsx’ file in Excel.

2. Edit The values in the respective sheet you need to update.

   Note

   An update should only every require an edit on the Rates, 2nd Parcel or Delivery Times sheets.

   The Zones sheet should not be edited as it’s structured for external services.

   Learn more about adding shipping categories in the generator docs.

3. Save the file and close Excel.

4. Run the generator process as described above.