BV Commerce Forum
»
BV Commerce Support
»
General Support
»
Is it possible to extract a report with product choices/modifiers in separate columns?
Rank: Member
Joined: 6/1/2004(UTC) Posts: 720
|
I believe that the product choices/modifiers relating to a product all go into one column and are separated only by a return. Is there a way to extract the data such that it would force the different product choices and modifiers into separate columns?
Thanks, Derek |
|
|
|
|
Rank: Member
Joined: 4/10/2009(UTC) Posts: 120 Location: Mechanicsville, VA
Thanks: 3 times Was thanked: 1 time(s) in 1 post(s)
|
You are talking visually? Like you want the choices to display horizontal instead of vertical? Or tabular-ly into 2 columns? This can all be done through CSS. |
Tim
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC) Posts: 1,786
|
One problem is that from a programming stand point product A can have 1 property and product B might have 7. How can you create columns in the cart when you don't know how many properties will be available for display?
|
|
|
|
Rank: Member
Joined: 6/1/2004(UTC) Posts: 720
|
thanks Marcus!
What I am after is not to display columns in the card itself but to extract information to spreadsheet after an order is taken right now for example if John Smith placed an order for product a, size extra large, blue in color, with only a logo on the back, the logo being style X.
When I extract the order data from the example above it would have first name equals John, last name equals Smith, product a... but the next column would include all the product choices/modifiers together. What I'm trying to accomplish is to have the modifiers broken out into their own columns.
Thanks... hopefully this makes sense :-)
Derek |
|
|
|
|
Rank: Member
Joined: 11/25/2003(UTC) Posts: 370
|
What Marcus is telling you still applies. The only way around it would having all modifiers the same for every product. Then it may be possible. You could also construct the spreadsheet on the fly with individual columns but coding and results would not be pretty. |
|
|
|
|
Rank: Member
Joined: 6/1/2004(UTC) Posts: 720
|
Hi Kim,
Actually this is the case in my situation. This is collecting event registration information and all 5 events have exactly the same choices/modifiers. It doesn't have to be pretty, just function allowing the data to be extracted. How would the s/s be created on the fly?
Thanks, Derek |
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.