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

CSV Specific price

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

10 comments about "CSV Specific price"

4/5 based on 10 comments

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

Description

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.

Demo Backoffice

User: demo@demo.com

Password: demodemo

Demo Front Office

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.

-----------------------------------------
Change history for CSV Specific Price
-----------------------------------------

VERSION 2.5.8 (22/05/2019)

  • * FIX: correctly eliminate specific prices when you are importing by reference
  • * ADD: related modules tabs

VERSION 2.5.6 (14/11/2018)

  • * ADD: change author module
  • * ADD: upgrade logo
  • * ADD: icons in configuration tabs

VERSION 2.5.3 (26/07/2018)

  • * FIX: now it is possible to update pricing rules
  • * ADD: now you have the option to delete only the specific prices that you are importing
  • * FIX: PrestaShop validator standards code structure

VERSION 2.5.0 (04/05/2018)

  • * ADD: ps_versions_compliancy min: 1.6, max: _PS_VERSION_
  • * ADD: PrestaTrust certified

---

VERSION 2.4.0 (04/05/2018)

  • * ADD: ps_versions_compliancy min: 1.5, max: 1.5.9.9

VERSION 2.3.6 (30/01/2018)

  • * ADD: new button in import tab that allow delete all specific prices

VERSION 2.3.5 (14/12/2017)

  • * FIX: now it is possible add specific price with from_quantity = 0

VERSION 2.3.4 (02/11/2017)

  • * FIX: now it is possible to indicate a fixed price with discount

VERSION 2.3.3 (10/07/2017)

  • * FIX: validate time problem with hours in date from and date to

VERSION 2.3.2 (11/04/2017)

  • * FIX: now is possible export with ids or reference and names (product reference, customer group, customer email and attribute reference)

VERSION 2.3.1 (05/01/2017)

  • * FIX: now is possible to indicate the hour and minutes for the specific price

VERSION 2.3.0 (19/09/2016)

  • * FIX: Fatal error: Call to undefined function oSQL() when import specific prices for customer email
  • * FIX: check and change the row's validation

VERSION 2.2.8 (19/09/2016)

  • * FIX: compatible with PrestaShop 1.7

VERSION 2.2.7 (02/09/2016)

  • * FIX: consider file types |application/octet-stream| when importing
  • * FIX: delete specific prices existing after checking if the file is correct (when you want to delete existing specific prices)

VERSION 2.2.5 (03/05/2016)
 * ADD: translations in co,ar,mx
 * ADD: select import specific prices by product referece or product id

VERSION 2.2.3 (25/04/2016)
 * FIX: problems export in multishop

VERSION 2.2.2 (18/03/2016)
 * FIX: problems when upload prices with numeric reference

VERSION 2.2.1 (05/01/2016)
 * ADD: import with id_product_attribute or product attribute reference

VERSION 2.2.0 (07/12/2015)
 * FIX: considerate reduction_tax

VERSION 2.1.9 (25/11/2015)
 * ADD: import with id_customer or customer email

VERSION 2.1.8 (12/11/2015)
 * FIX: ps_round in price and reduction in export
 * FIX: considerate file type application/force-download as valid file to import
 * ADD: class CSVSpecificPrice to export and import
 * FIX: error export if not specific prices created
 * ADD: field reduction_tax
 * ADD: select export fields
 * FIX: refinate validate row
 * ADD: import with id_product or reference
 * ADD: import with id_country or country name
 * ADD: import with id_group or group name

VERSION 2.0.8 (04/06/2015)
 * FIX: delete validation price

VERSION 2.0.7 (09/05/2015)
 * FIX: change all getContent()
 * ADD: configuration variable to delete specific prices existing
 * FIX: getSpecificPricesByShop()
 * FIX: change display fields
 * ADD: admin tabs
 * ADD: import log
 * FIX: change index security
 * FIX; change header file information
 * FIX: validate and control fields
 * ADD: Readme.md

VERSION 1.9.7 (13/12/2014)
 * ADD: changelog.txt
 * FIX: public $separator;
 * FIX: replace strtotime(date('d-m-Y')) by strtotime(date('d-m-Y H:i:s'))
 * FIX: delete unlink($file_import);
 * FIX: replace $_POST by Tools::getValue()
 * FIX: getSpecificPrices order by id_product
 * FIX: change index security

VERSION 1.9 (04/09/2014)
 * FIX: Notice A non well formed numeric value encountered

VERSION 1.8 (20/08/2014)
 * ADD: 2 columns: ref product, ref attribute
 
VERSION 1.7 (22/07/2014)
 * FIX: $output by $this->output
 * FIX: change tab export
 * ADD: change admin module with tabs
 * ADD: create a csv demo
 * ADD: bootstrap
 * ADD: module key
 * FIX: displayConfirmation and displayError
 * FIX: save and update rows

VERSION 1.6.0
 * FIX: Float reduction

VERSION 1.5.0
 * FIX: Float price
 * FIX: Add and update price specific
 * FIX: Add several product-specific prices

VERSION 1.4.0
 * FIX: SpecificPrice programmed using class

VERSION 1.3.0
 * FIX: Contemplate file type application/vnd.ms-excel
 * FIX: Clean code
 * ADD: Translations, available in spanish and english.

VERSION 1.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

Related products

Do you have any question?

Send a message to the marketing department.

help Send a message


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

€49.99
Instalation
Technical support and updates
Licenses

archive Dowonloaded more than 500 times

Compatibility
PrestaShop v1.5.0.0 - v1.7.6.0

Version
2.5.8 (22/05/2019)

(*) Available languages

Superhero seller

Expertise Level: Superhero seller
View catalog in PrestaShop Addons

Can't find the module you are looking for?

We offer the service to do custom developments

Request a quote