Import/Export Volume Price

[Ron Frigon]

Hey Guys,

I found the Import/Update csv template for updating the Volume Price, but I can't find an example for how to use the template. The headings are only PRICE_GROUP, PRODUCT_CODE, numbered 1 - 1000. How do I set this for fixed/absolute/percentage/ranges/prices... etc. Could you post an example?

Normally I would just set up one item then export, but there doesn't seem to be an export function for Volume Price or even a way to include it in the Product Export.

I've searched through the docs and can't seem to find any info there...

[Ron Frigon]

Re: Import/Export Volume Price

Here's an example of my volume pricing for 2 different price groups, for the same product. It works fine, I just can't figure out how to import/export the info...

Name: Volume Price - Retail
Eligibility: All Shoppers
Type: Volume Pricing
Grouping: All Eligible Products
Pricing Table: left empty and set at the product level
Priority: 0
Exclusions: Exclude for Same Basket


Pricing example for specific Eligible product


Quantity Type Amount
1 Absolute $13.95
2-4 Absolute $13.50
5-9 Absolute $12.95
10+ Absolute $11.95

---------------------------


Name: Volume Price - Wholesale
Eligibility: Specific Customers
Type: Volume Pricing
Grouping: All Eligible Products
Pricing Table: left empty and set at the product level
Priority: 100
Exclusions: Exclude for Same Basket


Pricing example for specific Eligible product (same product as above)


Quantity Type Amount
1-9 Absolute $7.00
10+ Absolute $5.60

[burch]

Re: Import/Export Volume Price

The columns work like this:

PRODUCT_CODE: The code of the product with volume pricing
PRICE_GROUP: The name of the volume pricing price group
1-1000: The low value of the range. The high value of the range is automatically determined based on the presence of other "number" columns, with the last range assumed to be "+"

The type of the discount is based off of the value in the "number" column. If the value is negative, it is treated as a fixed discount. If it ends with "%", it is treated as a percentage discount. Otherwise, it is treated as an absolute price. Empty values are ignored and do not create a volume pricing break.

So, given your product example above, you would want the following columns:
PRODUCT_CODE,PRICE_GROUP,1,2,5,10

And values like this:
product_code,Volume Price - Retail,13.95,13.50,12.95,11.95
product_code,Volume Price - Wholesale,7.00,,,5.60

[burch]

Re: Import/Export Volume Price

I forgot to add that we do not currently have a way to export the volume pricing table.

[Ron Frigon]

Re: Import/Export Volume Price

I forgot to add that we do not currently have a way to export the volume pricing table.

But it's going to be added right?

Thanks for the info!

[Ron Frigon]

Re: Import/Export Volume Price

Ok, finding this to be much more challenging than it needs to be... I can't think of any way to get this to work for this import format, with the price needing to be in column 240 for example.

I see there may be a way to do this via xml?

This is a small example of how I can export/format from our database. Any Excel "Experts" out there?

PRODUCT_CODE
PRICE_GROUP
From QTY
Price

1008
Volume Price - Wholesale
1
3.60

1008
Volume Price - Wholesale
240
2.90

1008
Volume Price - Retail
1
18.95

1010
Volume Price - Wholesale
1
4.10

1010
Volume Price - Wholesale
72
3.30

1010
Volume Price - Retail
1
19.95

1056
Volume Price - Wholesale
1
7.00

1056
Volume Price - Wholesale
10
5.60

1056
Volume Price - Retail
1
13.95

1056
Volume Price - Retail
2
13.50

1056
Volume Price - Retail
5
12.95

1056
Volume Price - Retail
10
11.95

1087
Volume Price - Wholesale
1
30.00

1087
Volume Price - Retail
1
30.00

1100
Volume Price - Wholesale
1
1.85

1100
Volume Price - Wholesale
60
1.50

1100
Volume Price - Retail
1
12.95

1102
Volume Price - Wholesale
1
14.25

1102
Volume Price - Wholesale
18
11.40

1102
Volume Price - Retail
1
12.95

1111
Volume Price - Wholesale
1
13.95

1111
Volume Price - Retail
1
19.95

1139
Volume Price - Wholesale
1
2.60

1139
Volume Price - Wholesale
120
2.10

1139
Volume Price - Retail
1
8.95

1154
Volume Price - Wholesale
1
20.40

1154
Volume Price - Wholesale
20
17.00

1154
Volume Price - Retail
1
12.95

[Ron Frigon]

Re: Import/Export Volume Price

I've edited the sample data. Some of the items need to be in a Specific Sale Price group since they don't actually have a volume price, just a different price.

PRODUCT_CODE
PRICE_GROUP
From QTY
U Of M Price

1008
Volume Price - Wholesale
1
3.60

1008
Volume Price - Wholesale
240
2.90

1010
Volume Price - Wholesale
1
4.10

1010
Volume Price - Wholesale
72
3.30

1056
Volume Price - Wholesale
1
7.00

1056
Volume Price - Wholesale
10
5.60

1056
Volume Price - Retail
1
13.95

1056
Volume Price - Retail
2
13.50

1056
Volume Price - Retail
5
12.95

1056
Volume Price - Retail
10
11.95

1100
Volume Price - Wholesale
1
1.85

1100
Volume Price - Wholesale
60
1.50

1102
Volume Price - Wholesale
1
14.25

1102
Volume Price - Wholesale
18
11.40

1139
Volume Price - Wholesale
1
2.60

1139
Volume Price - Wholesale
120
2.10

1154
Volume Price - Wholesale
1
20.40

1154
Volume Price - Wholesale
20
17.00

[Brennan]

Re: Import/Export Volume Price

If modifying your data to get it in the format the import needs there is an XML way with provisioning:

<Module code="discount_volume" feature="discount">
    <ProductPricingTable group_name="Volume Pricing Component Test 04" product_code="discount_volume_component_01">
        <Entry quantity="17" type="percent" amount="10" />
        <Entry quantity="20" type="absolute" amount="73.80" />
    </ProductPricingTable>
</Module>

[abdeek]

Re: Import/Export Volume Price

Two questions:
1 - We're using Emporium-Plus volume-pricing (quantity based) on nearly a hundred thousands products. The import template differs from MM9. Do we need to start from scratch or is there a way to migrate from the old module?


2- Can we view the discount table on the product page (before adding to the basket)?

[Ron Frigon]

Re: Import/Export Volume Price

Hey Brennen,

Is there also a way to assign products to a price group via xml provisioning? It appears the items need to be assigned to the group first. Maybe it can be included in the snippet you provided and be assigned at the same time?

Thank You!

[Brennan]

Re: Import/Export Volume Price

Yes. Attached is a sample XML file with all the provisioning tags supported by the module.

[Brennan]

Re: Import/Export Volume Price

@abdeek

No you don't need to start from scratch, but you will need to modify your existing import file into the format Miva is expecting. This should be possible coming from the emporium plus import format using excel.

Yes you can also view the discount table on the product page. See this post on the instructions:

http://extranet.miva.com/forums/show...812#post425812

[Ron Frigon]

Re: Import/Export Volume Price

No you don't need to start from scratch, but you will need to modify your existing import file into the format Miva is expecting. This should be possible coming from the emporium plus import format using excel.

I don't believe this is true:

3333#0|1|12.95^\r\n2|4|12.50^\r\n5|9|11.95^\r\n10|+|10.95^#1##

If there is a procedure to convert the data above from Emporium Plus Volume Pricing into the format that Miva needs to Import, please share.

I've been experimenting converting this into excel and xml. Even with the data samples I show above and using the templates you've provided, this will not be an easy conversion.

[Brennan]

Re: Import/Export Volume Price

Looking at this in more detail, we're probably going to need to build a conversion tool for this. Simple volume pricing can be converted but once you start having products with different levels of pricing it can get far more complex.

[crozon]

Just wondering if a conversion tool was built for this? We have thousands of products and unfortunately each has it's own pricing structure and are looking for some way to import the volume pricing tables without having to manually enter each one. Any help would be greatly appreciated.