Installation and configuring plug-in NopPriceImportExport

1. The file format for import/export/update prices.

2. The two columns file format import/update prices.

3. FAQ (Import prices)

4. FAQ (Export prices)

5. FAQ (Update prices)

1. The file format for import/export/update prices

You should use CSV file (comma separated values).
Each file has rows with such format


Id,Sku,Gtin,ManufacturerPartNumber,Price,ProductCost,OldPrice,SpecialPrice,TierPricePairs

Id – The product identifier (from the current store). Required. Larger then 0.
          Note. Different stores can have different product ids. 0 is wrong value.
Sku - Product stock keeping unit (SKU). Can be empty.
Gtin - GTIN (global trade item number). Can be empty.
ManufacturerPartNumber - Manufacturer part number. Can be empty.
Price - The price of the product. Required. Example. 1245.12, 0.99, “1234,99”, “0,99”.
ProductCost - Product cost. Required. Example. 1245.12, 0.99, “1234,99”, “0,99”.
OldPrice - Old price. Required. Example. 1245.12, 0.99, “1234,99”, “0,99”.
SpecialPrice - Special price. Can be empty. Example. 1245.12, 0.99, “1234,99”, “0,99”.
TierPricePairs – Tier Price Pairs. Can be empty. It has the next format


{Quantity:Price;Quantity:Price;Quantity:Price; ... }

Note. String begins from {, and ends }. Each pair has the next format Quantity:Price.
Quantity – Numeric. Example. 1, 2, 36.
Price –  Example. 1245.12, 0.99, “1234,99”, “0,99”.


Example.

59774,,,,35,0,0,,
59775,,,,"43,5",0,55,,{}
36,,,,"43,5",0,55,,{3:40;6:38;10:35;}
50150,,,,"43,5",0,55,,{}

Analyze the first row:   59774,,,,35,0,0,,


Id – 59774.
Sku - none.
Gtin - none.
ManufacturerPartNumber - none.
Price - 35
ProductCost - 0
OldPrice - 0
SpecialPrice - none
TierPricePairs – none



Analyze the third row:   36,,,,"43,5",0,55,,{3:40;6:38;10:35;}


Id – 36.
Sku - none.
Gtin - none.
ManufacturerPartNumber - none.
Price – 43.5
ProductCost - 0
OldPrice - 55
SpecialPrice - none
TierPricePairs –
a) for quantity 3 price 40
b) for quantity 6 price 38
c) for quantity 10 price 35

2. The two columns csv-file format for importing prices

You should use CSV file (comma separated values).
Each file has rows with such format


ProductKey,KeyPrice


ProductKey => Id,Sku,Gtin,ManufacturerPartNumber


KeyPrice => Price,ProductCost,OldPrice,SpecialPrice


3. FAQ (Import prices).


1. I want to import/update prices in my store.
     Answer.
     You should use Product Id as key.


2. I want to import/update prices from another store.
    Answer.
    You should use Sku,  Gtin or ManufacturerPartNumber as key.


3. I want to update product prices from the file with 20% discount using existing Old price from you own store.
    Answer.
    See image


4. I want to create tier price for quantity = 5 using existing price value from the csv file.
    Answer.
    See image


4. FAQ (Export prices).


1. I want to export prices from the category Computers and subcategories.
     Answer.
     See image. You will have a csv file. Read about fortmat of this file link.


5. FAQ (Update prices).


1. I want to update Price value for all products from the category Computers and subcategories with markup 20% from existing price cost.
     Answer.
     See image


2. I want to create/update new Tier Price for quantity 5 for all products from the category Computers and subcategories with discount 10% from existing price.
     Answer.
     See image