Installation and configuring plug-in Price Manager 1. The file format for import/export/update prices. 2. Simple the two columns csv-file format for importing prices. 3. Simple 3-7 columns csv-file format for importing tiers prices. 1. The file format for import/export/update prices for NopCommerce 4.xx Id,Price,ProductCost,OldPrice Old Nopcommerce versions have another csv format Id – The product identifier (from the current store). Required. Larger then 0. Note. String begins from {, and ends }. Each pair has the next format Quantity:Price. Note. String begins from {, and ends }. Each pair has the next format Quantity:Price. This document can help you to create CSV file Analyze the fourth row: 36,,,,"43,5",0,55,,{3:40:1;6:38:1;10:35:3:2:30/06/2018;} 2. Simple two columns csv-file format for importing prices. TierPricePairs – Tier Price Pairs. Can be empty. It has the next format Note. String begins from {, and ends }. Each pair has the next format Quantity:Price. {3:40;6:38;10:35;} TierPricePairs – {3:40:1;6:38:1;10:35:3;} TierPricePairs – 3. Simple 3-7 columns csv-file format for importing tiers prices. We added new format for importing tiers prices (nop 3.90, 4.00 and never) ProductKey,Price,Quantity,CustomerRoleId,StoreId,StartDateTime,EndSateTime ProductKey => Id,Sku,Gtin,ManufacturerPartNumber Quantity => Quantity CustomerRoleId => CustomerRoleId (you can skip this column) StoreId => StoreId (you can skip this column) StartDateTime=> StartDateTimeUtc(you can skip this column), format dd/MM/yyyy or yyyy-MM-dd hh:mm:ss EndSateTime=> EndSateTimeUtc(you can skip this column), format dd/MM/yyyy or yyyy-MM-dd hh:mm:ss Example 1: => 12451 - product key, 12.25 - price, 8 - quantity, 6 - cutomer role Id, 1 - store Id.
You should use CSV file (comma separated values).
Each file has rows with such format
Id,Price,ProductCost,OldPrice,TierPricePairs
for NopCommerce 3.90
Id,Sku,Gtin,ManufacturerPartNumber,Price,ProductCost,OldPrice,TierPricePairs
for NopCommerce 3.80 and older
Id,Sku,Gtin,ManufacturerPartNumber,Price,ProductCost,OldPrice,SpecialPrice,TierPricePairs
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”.
(removed from nop 3.90) SpecialPrice - Special price. Can be empty. Example. 1245.12, 0.99, “1234,99”, “0,99”.
TierPricePairs (plain format) – Tier Price Pairs. Can be empty. It has the next format
{Quantity:Price;Quantity:Price;Quantity:Price; ... }
Quantity – Numeric. Example. 1, 2, 36.
Price – Example. 1245.12, 0.99, “1234,99”, “0,99”.
TierPricePairs (full format from nop 3.90) – Tier Price Pairs. Can be empty. It has the next format
{Quantity:Price:CustomerRoleId;Quantity:Price:CustomerRoleId; ... }
{Quantity:Price:CustomerRoleId:StoreId;Quantity:Price:CustomerRoleId:StoreId; ... }
{Quantity:Price:CustomerRoleId:StoreId:StartDate;Quantity:Price:CustomerRoleId:StoreId:StartDate; ... }
{Quantity:Price:CustomerRoleId:StoreId:StartDate:EndDate;Quantity:Price:CustomerRoleId:StoreId:StartDate:EndDate; ... }
Quantity – Numeric. Example. 1, 2, 36.
Price – Example. 1245.12, 0.99, “1234,99”, “0,99”.
CustomerRoleId – Example. 0, 1, 2, (0 - for all customer roles) or customer role name (ex. Administrators)
StoreId – Example. Example. 0, 1, 2.
StartDate – Example. format dd/MM/yyyy or yyyy-MM-dd hh:mm:ss
EndDate – Example. format dd/MM/yyyy or yyyy-MM-dd hh:mm:ss
https://docs.google.com/spreadsheets/d/1-mlJujsFNz5TW1dAy3EMNSyJPjW42JXHEpnxS5nVrWQ/edit#gid=0
Example.
59774,,,,35,0,0,,
59775,,,,"43,5",0,55,,{}
36,,,,"43,5",0,55,,{3:40;6:38;10:35;}
36,,,,"43,5",0,55,,{3:1:40;6:1:38;10:3:35;}
Analyze the first row: 59774,,,,35,0,0,,
Id – 59774.
Sku - none.
Gtin - none.
ManufacturerPartNumber - none.
Price - 35
ProductCost - 0
OldPrice - 0
(removed from nop3.90) 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
(removed from nop3.90) SpecialPrice - none
TierPricePairs –
a) for quantity 3 price 40
b) for quantity 6 price 38
c) for quantity 10 price 35
Id – 36.
Sku - none.
Gtin - none.
ManufacturerPartNumber - none.
Price – 43.5
ProductCost - 0
OldPrice - 55
(removed from nop3.90) SpecialPrice - none
TierPricePairs –
a) for quantity 3, price 40, customerRoleId 1
b) for quantity 6, price 38, customerRoleId 1
c) for quantity 10, price 35, customerRoleId 3, storeId=2, startdate 30.06.2018
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,(removed from nop 3.90) SpecialPrice, (added from nop 3.90) TierPricePairs
{Quantity:Price;Quantity:Price;Quantity:Price; ... }
Quantity – Numeric. Example. 1, 2, 36.
Price – Example. 1245.12, 0.99, “1234,99”, “0,99”.
a) for quantity 3 price 40
b) for quantity 6 price 38
c) for quantity 10 price 35
a) for quantity 3 and customerRoleId 1 price 40
b) for quantity 6 and customerRoleId 1 price 38
c) for quantity 10 and customerRoleId 3 price 35
Price => Price
12451,12.25,8,6,1
Example 2:
128741,182.25,8
=> 128741 - product key, 182.25 - price, 8 - quantity.
Example 3:
128741,182.25,8,6
=> 128741 - product key, 182.25 - price, 8 - quantity, 6 - cutomer role Id.
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 with discount 10% using existing price value from the csv file.
Answer.
See image
1. I want to export prices from the category Computers and subcategories.
Answer.
See image. You will have a csv file. Read about format of this file link.
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