Reorder products with attributes

[CartCrazy]

I have a big problem.

We have a software. How it works is, if you use our service, you download our software and create a custom product. Once you upload the custom product for us to 'finish', the software provides you with a shopping cart URL. this URL has the info of the characteristics of your custom product - attributes. Now when you login, you see your custom product, its attributes and the price for it.

You cannot edit the attributes. We did special coding in such a way that the info pulled from the shopping cart URL is displayed in your order page but you cannot edit them. The price is dependent on the attributes.

Now the main problem starts....how can a user place reorder? How can a user add the product to a Wish List?

When placing a reorder, the original product shows up but not its Attributes. Only with the help of one of the attributes can we identify the order. Same goes with Wish list ( that is if a person uploads the custom product and logs in but then wants to order it at a later time, then he needs to save it some where right? We did not like it saved in the shopping cart. So we added the wishlist mod. ).

we all know that wishlist and quick reorder do not copy the attributes to place an order again.

However, i noticed something VERY WEIRD but GOOD.

After we added the wishlist mod, ONE of the attributes is being passed and it shows up. This is soo cool. However, the other one is not showing up. ( We need both to identify your order and price correctly). We know that wishlist is not supposed to show any of the product attributes. But it does show the product attribute one. And after adding the wishlist mod, now even the quick order shows one of the attributes.

My main issue is, i need a zen cart and PHP expert who can see why one of the attributes is in fact showing up filled in, and how can can use the same logic to pull the other attribute as well.

If we can get both attributes filled in, my problem is solved.

Can you help? Can you tell me where to go for help?

This is almost the last thing left in my cart to launch the site.

[CartCrazy]

I was just looking at the SHOPPING CART (more) Side Box.

If we click on a product in the shopping cart, we get all the attributes of that product as well.

What is we use the similar code to reorder? May be we need to change the table where to look for the info.

But if we click on a button in the order history page called reorder, then we should be able to get the entire product and its attributes and a add to cart button.

Is that do able?

Does anyone know of any coder in PHP? I keep putting calls in commercial help wanted section but no one ever replies.

[CartCrazy]

Can anyone help? Please? This is a SOS situation.

I am not sure if anyone sees my posts.

[Ajeh]

The attributes are stored in using the products_id, products_options_id, products_options_values_id, products_options_values_text and products_options_sort_order in the customers_basket_attributes

If you look in the customers_basket you will see the related Product ...

Note the products_id ... example:
46:c5e309dd582d3e7b3c7c800281d1a885

46 is the products_id ...

c5e309dd582d3e7b3c7c800281d1a885 is just a method to distinguish which attributes go to which products_id when you have the same products_id with a different combination of attributes ...

Sometimes this may appear to be the same, and sometimes it changes ... the point is, it links the two tables together to keep the product and associated attributes together ...

Make an order with products with attributes and complete it like a customer ...

Now, go look at the orders_products and orders_products_attributes tables ...

Do you see the products_id?

Look a little further and you will see the products_prid ... that is the products_id:attributeskey

Look in the orders_products_attributes table ...

See the orders_products_id in there? Now look a little further and you will see:
products_options_id, products_options_values_id and the products_prid

You can build the products for the cart for a re-order using these same values ...

Just be careful if you use Downloads ... I had to do some wicked elfin magic rebuild a product with downloads ...

[CartCrazy]

I gave your instructions and the query worked.

Then it took me a real long time to know where to make updates.

Finally, I updated these two files

tpl_order_history.php

order_history.php

Now, everything works. Cool!!!!

However, a small issue is this:

I only see one item in the order-history side box though I have ordered a few. How can is see more than one?

[Ajeh]

Peek in the Maximum Values:

Recent Purchases Box- NOTE: box is disabled
Number of products to display in the recent purchases box

[CartCrazy]

I looked...I had it set as 6.

I never noticed it till now. But I am sure that this has happened all the time. Even before I made changes..I would only see one item.

Could it be that my side box is small? Should I include more height or something?

[CartCrazy]

Did you see this thread:

forums.oscommerce.com/index.php?showtopic=309979&pid=1284920&st=0&#entry1284920

This is a cool function in OSCOMMERCE. this is what we are working on...i wish we had it for Zen cart too. I dont know why my order history shows

1. Product name instead of Order ID or JobID that identifies every item in the order. Users can have many orders for the same product but you see, there are different attributes. So I wish the quick reorder had orderID and not product as an entry.

2. I wish the reorder worked just like the VIEW in the accounts history page. Just a click and all the info in that order will go as another order.

But on later thoughts, i think view shows an order with multiple products in it. What if the user wants to order just one product....so i guess the quick reorder cannot have the orderID as the identifying factor.

Hmm,.....now thinking of it, I am in a soup.

The reorder in my case should work like this:

1. Every item ordered should be available for reorder.

2. The reorder capability should be next to every item ordered.

Man..i feel so dejected..after all the hard work, i see that the way reorder is working, wont really work for me.

Oh god...does anyone have a solution?

[Ajeh]

I don't have a solution handy, but one can always be written to manage a way to add to cart from the existing order on a per product basis so that the customer can actually move between any orders that they have made and just click along and update the shopping cart from them ...

Not a simple processes, but not a killer either ...

Just need some time and patience ...

The information is all there to rebuild a product plus the attributes to add to the shopping cart ...

Biggest issues is if there are downloads ... those are hard to rebuild from the orders ...

As to the osC add-on ... just have to translate it, if this can actually do what you want it to do ...

[CartCrazy]

I think I need commercial help.