Importing 2 prices per product

[FluidFusion]

I have 700 products that have 2 prices each which relate to 2 different customer groups, 'Wholesale' and 'Trade'.

Does anyone know how you can import 2 prices and have them assigned to the different customer groups. There does not appear to be an import field for additional pricing.

Also, the site will be set up for registered users to purchase only. Does this make a difference??

Steve

[gabrielcrowe]

after you import one of your prices, you could always create a custom field and use that for your trade prices.

[Goz]

I think you should create a product in Actinic with the custom variables that you want i.e. with the extra price field, and then get the layout working as you want it.

Then use the File > Export facility. This will give you all the standard fields plus the custom variables. You can create further lines based on this and import back into Actinic.

HTH.

Andy

[leehack]

Also, the site will be set up for registered users to purchase only. Does this make a difference??

Certainly does, half your visitors at least will leave.

Are your prices a set percentage off? If so you could create groups and have their prices automatically created for you by actinic. I'd try and move to this method if possible, you can override if any anomalies or any special circumstances on certain products is required.

[FluidFusion]

I agree

Certainly does, half your visitors at least will leave.

Are your prices a set percentage off? If so you could create groups and have their prices automatically created for you by actinic. I'd try and move to this method if possible, you can override if any anomalies or any special circumstances on certain products is required.

But this is not a shop open to the public, more a solution to ease the strain of telephone orders.

[FluidFusion]

I cannot believe that this is not importable through a CSV, it should be.

What is the point in being able to set different prices depending on the customers login group if you can't upload those prices. I guess it's fine if you are a startup company with no prices already but does not lend well to my situation.

I guess, I will just import the information into the product description field and then go through each product and cut and paste into into the right boxes.

[leehack]

Can't you convert to percentages off and make it easier?

[FluidFusion]

Cant convert to percentages as each there is a strict price in place that does not equate over the range of products. Ever product is priced differently.

I think I will just get stuck in! Will be late late one tonight!

[FluidFusion]

Well, it's a year on since I originally posted this.

Does anyone know a way of doing this now?

Would really appreciate if someone has had the same problem and found a solution.

[dallen]

It can be imported, and I think always could.

you need to do it via a hierarchical import.

the header for Price looks like:

Header:Price,Customer Group,Price,Generated,Can be Ordered,Product Visible,Minimum,Customer Message,IsDeleted

and an entry for an item would look like:

Price,CustomerGroup1,500,0,1,1,,,0
Price,CustomerGroup2,600,0,1,1,,,0

have a go at setting one or two up manually, then export the catalog and find the lines relevant to it. You should then be able to create an import sheet for what you need to do.

[brant@on-one]

Can't you change your business pricing model? We used to have all that "different product different prices" carry on - now we have 2 groups - one we give X% to, another we give Y% to. It's much easier ;-)