Update SKU parameters

Modified on Tue, 4 Feb at 3:58 PM

TABLE OF CONTENTS


Introduction


Multiply calculates price bounds based on your parameters to define the price range within which it can recommend prices. It is essential to set up these parameters and keep them updated to ensure accurate recommendations.

The data linked to an SKU is stored in Multiply and can be replaced or deleted as needed.



Method 1 : manual entry for an SKU


This method allows you to enter parameters directly on the product screen in Multiply, one offer at a time, whenever you want. From the following parameters can be updated.

 

Pricing > Product > ... > Price bounds


  • Bound parameters (reference price, minimum and maximum, margin rates)
  • Hard bounds
  • Auto pricing
  • VAT rates
  • Costs


Method 2 : uploading a file manually


This method allows you to manage the parameters of one or several SKUs by importing a file, enabling you to update multiple offers at once within a single catalog directly on your Multiply portal. Ensure that the file adheres to the column names that Multiply can read.


Essential conditions for file processing


  • The file must include skus.
  • The file must be in .txt, .csv, or .xlsx format
  • The file must be tab-delimited.
  • Column names are case-sensitive and must follow the exact spelling as specified (see the table below).
  • Decimal numbers should be written with a period (".").
  • To delete integrated data, the cell must contain [NULL].
  • Each file import is associated with a specific catalog; to modify parameters for multiple catalogs, perform an import for each catalog.


Steps to import a file


  1. Go to Import and Export > Import Catalog.
  2. Choose your catalog.
  3. Add your file.
  4. Click Send.


Data You Can Import into Multiply


Please find below the mostly frequent used data to import : 


You can used the report Catalog Data Report as a template and keep the headers you need ( delete the others).



HEADERVALUE
skuMandatory
reference_listing_price_inc_vatReference price including VAT
ean13EAN code
weight_kgWeight of your product in kilos
reprice

TRUE = enable auto pricing

FALSE = disable auto pricing

active

TRUE = force SKU as active

FALSE = force sku as inactive

overridden_shipping_price_inc_vatThis value will replace the shipping fee recovered in the marketplace API. It willonly be used to calculate your bounds and target price. It will not replace your current shipping price on the marketplace.
pricing_strategy_id= please contact a team member of the Customer Success Team
costs.cost_of_goods_sold.amountCost of your product VAT excluded
min_safe_price_inc_vatHard min listing price including VAT
max_safe_price_inc_vatHard max listing price including VAT
min_listing_price_inc_vatMinimum listing price including VAT
max_listing_price_inc_vatMaximum listing price including VAT
min_landed_margin_rateMinimum landed margin rate
max_landed_margin_rateMaximum landed margin rate
min_listing_margin_rateMinimum listing margin rate
max_listing_margin_rateMinimum listing margin rate


Import Results


Multiply displays the result of each importation.


Import and Export > Imported feeds


Blue arrow allows you to download your feed.

File symbol is a report that displays the exact data that has been imported in Multiply

A screenshot of a computer 
Description automatically generated



A screen shot of a computer

Description automatically generated

The stream or file does not contain any errors preventing its reading. 

There is an available integration report because data has been imported.

A screenshot of a computer error message

Description automatically generated

The stream or file does not contain any errors preventing its reading.

The content is not valid and prevents data integration

You can view the errors by clicking on "View errors." 

There is no integration report available because the data has not been imported.

The stream or file does not contain any errors preventing its reading. 

It contains some errors that need to be checked

You can view the errors by clicking on "View errors." 

There is an available integration report because data has been imported.

A screenshot of a computer error

Description automatically generated

The stream or file contains errors that prevent its reading

You can view the errors by clicking on "View errors." 

There is no integration report available because the data has not been imported.



Most commons errors

  • Missing SKUs (It could be on of the following reasons)
    • The file format is incorrect, preventing the reading of the "sku" column (file is not tab delimited)
    • "sku" header is missing
    • Some lines of the file are missing SKUs
  • Decimal numbers are written incorrectly, with comma for example.
  • The presence of misplaced symbols can disrupt the stream reading.



Method 3: configuring input Feeds


This method allows you to import your SKU parameters automatically on a daily basis using a feed, updating multiple offers across one or more catalogs simultaneously.


Essential conditions for feed processing

  • Provide Multiply with a URL.
  • Ensure the feed contains the SKUs and the data to be imported into Multiply.
  • Specify which column needs to be mapped.
  • Make sure your feed is available
  • Any change requires Multiply to be informed in order to change the integration parameters.


Force an import


By default, the integration runs every morning.

If you modify values in your input feed and need an immediate update, Multiply allows you to manually refresh the integration task. By refreshing manually, Multiply gets the updated data sooner and can adjust the parameters and price recommendations accordingly.


Tasks > Task Category = Integration > Load feeds > PLAY


If the taks fails, a message will display the reason.


Import Results


Multiply displays the result of each importation.


Import and Export > Imported feeds


Blue arrow allows you to download your feed.

File symbol is a report that displays the exact data that has been imported in Multiply

A screenshot of a computer 
Description automatically generated



A screen shot of a computer

Description automatically generated

The stream or file does not contain any errors preventing its reading. 

There is an integration report available.

A screenshot of a computer error message

Description automatically generated

The stream or file does not contain any errors preventing its reading.

The content is not valid and prevents data integration. 

You can view the errors by clicking on "View errors." 

There is no integration report available because the data has not been imported.

A screenshot of a computer error

Description automatically generated

The stream or file contains errors that prevent its reading. 

You can view the errors by clicking on "View errors." 

There is no integration report available because the data has not been imported.



Most commons errors

  • Missing SKUs
    • The file format is incorrect, preventing the reading of the "sku" column ( file is not tab delimited)
    • "sku" header is missing
    • Some lines are missing SKUs
  • Decimal numbers are written incorrectly, with comma for example.
  • The presence of misplaced symbols can disrupt the stream reading.



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article