CSV Specific price

WHAT THIS MODULE DOES FOR YOU

• Export and visualize in a CSV file all the specific prices that are in your shop.
• Save time management. Update specific prices of your shop with just a few clicks.
• Keep specific prices catalog updated in seconds.

FEATURES

This module allows you to export and import the specific prices or offer prices of your store quickly using a CSV file.

The configuration of the module is divided into 2 sections:

• Export
• Import

In the export section you can select the fields you want to export for your CSV file. All the fields in the specific price table are available for export.

In this csv file you can see at a glance all the specific prices that have been created in your store with the possibility to modify them quickly and use the import to update the catalog of specific prices.

The export can be done with names and references or with the identifiers.

In the import section you can bulk import large amounts of records in just one click saving a lot of management time.

The import allows you to modify existing specific prices or add new specific prices.

You can import specific prices indicating:

• The specific price identifier
• The specific price rule
• The cart identifier
• The product identifier or reference
• The shop identifier
• The shop group identifier
• The currency identififier
• The country identifier or country name
• The customer group identifier or group name
• The customer identifier or customer email
• The product combination identifier or reference
• The price
• The amount from which the specific price applies
• The reduction
• Tax in reduction or no
• The reduction type (amount or percentage)
• Date start
• Date end

The following options are also available when importing:

• Delete all specific prices before importing.
• Delete only the specific prices of the products included in the CSV file.
• Import specific prices by product reference.
• Remove all specific prices of your catalog to clean the database.

The errors control is very present in this complement. Each column is validated before inserting or updating a specific price. For each import a file with the errors report is generated.

IMPORT FIELDS

id_specific_price

This field represents the specific price's identifier. If this field is empty, a new specific price will be inserted, otherwise, the existing record with this identifier will change.

When importing, if this column does not exist in the CSV file, all the specific prices will be saved as new.

id_specific_price_rule

This field represents the specific price rule's identifier. Leave to 0 or delete column if this field is not used.

id_cart

This field represents the cart's identifier. You could add a specific price on a specific cart. Leave or delete column if this field is not used.

id_product

This field represents the product's identifier. Basically, prices are for a specific product. This field must indicate the product ID or reference. It is a required field.

id_shop

This field represents the ID of a shop. This field will be used in multishop system specific prices for each product and shop. Leave to 0 or delete this column if this field is not used.

id_shop_group

This field represents the ID of a shop group. This field will be used in multishop system specific prices for each product and shop group. Leave to 0 or delete this column if this field is not used.

id_currency

This field represents the currency's identifier. You can create different specific prices for each currency. Leave to 0 or delete this column if this field is not used.

id_country

This field represents the country's identifier or country name. You can create different specific prices for each country. Leave to 0 or delete this column if this field is not used or this specific price is for all countries.

id_group

This field represents the customer group's identifier or customer group name. You can create different specific prices for each customer group. Leave to 0 or delete this column if this field is not used or this specific price is for all customer group.

id_customer

This field represents the customer's identifier or customer email. You can create specific prices for a specific customer. Leave to 0 or delete this column if this field is not used.

id_product_attribute

This field represents the ID or reference of a combination. You can create specific price for a combination of a product. Leave to 0 or delete this column if this field is not used.

price

This field represents the final price with the reduction already added. This field is only used when we want to use the type of "amount" reduction setting the desired final price. In the case of type "percentage" reduction, this field must have the value -1. Let -1 or delete this column if this field is not used.

from_quantity

This field indicates the amount at which the specific price will apply. It is used to consider the volume discounts. Leave 1 or eliminate this column if this field is not used.

reduction

This field represents the reduction to be applied to the price either by percentage or amount. For example, if you apply a 20% discount, the value of this field shall be: 0.2. In case you want to use a type of "amount" field reduction should contain the monetary value of the discount. It is a required field.

reduction_tax

This field is used to indicate if the discount has including taxes or not. Available values: (0.1). If you fill this field with a value of 1 it means that the price including taxes. Leave 1 or delete this column if this field is not used.

reduction_type

This field represents the type of reduction that can be applied in Prestashop. You may indicate that reduction or discount is the amount or percentage of the price. In this case, the values that can have this field are: "amount" and "percentage".

from

This field represents the start date for a specific price. This means that you can indicate that a specific price will be applied from a certain date. Format date: dd/mm/yyyy hh:mm:ss. Leave empty or delete this column if this field is not used.

to 

This field represents the ending date of a specific price. From this date the specific price will no longer be available to customers. Format date: dd/mm/yyyy hh:mm:ss. Leave empty or delete this column if this field is not used.

First of all, click “Add new module” at modules tab on back office. You will find it in the top right. After that, select packaged file you have downloaded and click “Upload file”. Now your module appears on modules list. Click on “Install”, and “Configure” next.

You can also unload .zip file and upload it into your modules directory. In this way you will install and configure module from modules admin.

The purchase of this module includes 3 months of support (*) and 3 months free updates. (*) The technical support includes answering all your questions and doubts and resolve any issues having to do with the module. It excluded adaptations to different types of template and personalizations.

bug_report Technical support