CSV Specific price

Exports and imports quickly in CSV file all the specific prices or on offer of your shop.

Features

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.

Demostration details

Demo Backoffice

User: demo@demo.com

Password: demodemo

Demo Front Office

Instalation

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.

Support and updates?

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

Do you have any question?

Send a message to the marketing department.

help Send a message

10 comments about "CSV Specific price"

4/5 based on 10 comments

(6)
60%
(3)
30%
(1)
10%
(0)
(0)

10 comments about "CSV Specific price"

  • objetivo cumplido
    By on 03/15/2018

    resulta bastante complejo para usuarios inexpertos pero gracias a la ayuda del soporte técnico conseguimos nuestro obejtivo. El módulo cumple con toda su función y nos ha ahorrado un montón de tiempo. Gracias!!

  • good module !
    By on 07/04/2017

    I had a small problem to install the module and the team was reactive, thanks to them again, regards

  • Todo bien
    By on 05/22/2017

    todo perfecto y gracias por su apoyo

  • The module does what it says
    By on 07/14/2016

    Setup was easy and using it is straight forward. The module allowed us to apply what we wanted to hundreds of products (have special prices for a different country). Yours is the only module that support every single field in the specific pricing (such as changing base price, add country, customer group etc)

  • mejorar la usabilidad
    By on 04/16/2016

    el modulo finalmente funciona pero estaria bien que fuera un poco mas facil de usar. Al soporte tecnico le doy 5 estrellas

  • Great Product
    By on 07/29/2015

    Great Product, very usefull

  • ok
    By on 07/20/2015

    ok

  • Muy sencillo
    By on 05/05/2015

    Es muy cómodo para utilizar escalados de precios

  • César (Bonatinta)
    By on 05/16/2014

    Me fue genial para importar mas de 6mil productos (6000 productos), me ahorrado muchas horas de trabajo
    El proveedor de productos me envio su tarifa, yo la multipliqué por el beneficio que le queria aplicar. COPIAR, PEGAR, IMPORTAR listo... Gracias por el aporte

  • facil
    By on 05/16/2014

    muy rapido y facil de instalar, 1 minuto de reloj... puntuación 100% positivo

CSV Specific price

€49.99
Instalation
Technical support and updates
Licenses

Dowonloaded more than 500 times

Compatibility
PrestaShop v1.5.0.0 - v1.7.6.5

Version
2.5.11 (03/09/2020)

(*) Available languages

Superhero seller

Expertise Level: Superhero seller
View catalog in PrestaShop Addons

favorite_border Add to my wishlist

Would you like to be part of our team of web developers?