Is it possible to move assigned customers from one price group to another

[tammu]

I have couple of price groups and each have specific customers assigned to them.

But now I have requirement where I need to move all the customers assigned to price group A to price group B. There are over 2000 customers assigned to price group A.

Is there a way to do this in the marketing dashboard or do I have to use csv import export.

Thank you

[thilsabeck]

This data can be imported via XML. If you can get your customer data in this format you can import using the "Import Data via XML" import:

<PriceGroupCustomer_Assign group_name="20off" customer_login="customer123" />

[Kent Multer]

I think this can be done in a few minutes using phpMyAdmin to directly edit the database. That would be easier than importing, exporting, and messing around with XML. Or am I missing something?

[Rick Wilson]

Well for one, no one should be using phpMyAdmin to do things like that anymore, it's a whole host of problems including but not limited too we're taking away access to that in the future. So people shouldn't start relying on it today unless absolutely necessary.

[tammu]

Thanks for the replies, I don't need to change customer login information or anything just need to unassign from one price group and assign them to another one.

I was hoping there was a way to do this from the dashboard like selecting all the customers assigned in price group A and assign them to price group B.

Thanks

[rguisewite]

tammu I'd second what thilsabeck said. There isn't anything you could do directly from the interface. You could, however, go to Marketing > Price Groups, then select your price group A and click the Customers button. Show the customer login column if not already visible. Using the filters in the dialog, filter by assigned customers, then select all customer (Control+A or Command+A), then export to CSV. You could then take all those customer logins you exported and convert them to that PriceGroupCustomer_Assign provision tag and import that through data management. That'd probably be the easiest/cleanest way. I would not attempt to touch the database stuff directly. The chance of hosing your store is higher than I think you'd want. You could do all the unsassigning from the old price group directly from the interface.

Another alternative you could try would be to do an advanced search in price group B's customer dialog and search for all the logins (using Equal To comma separated list) and convert the downloaded csv logins into a comma separated list. Then you'd just select all the returned customers and assign. I'm not sure if you'll hit a DB search field max though (given the number of customers you're attempting to assign).