Reorder products with attributes

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.

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.

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

I am not sure if anyone sees my posts.

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 ... :smartalec:

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?

Peek in the Maximum Values:

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

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?

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?

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 ...

I think I need commercial help.

ou know what.....I think I have a new set of problems...or I am all over the place.

What I want essentially is this:

1. If a user logs in with the shopping cart URL, the product page shows up like this:
   

Now the attributes JobID and number of pages are the unique identifiers of every order. The JobID gets us the exact file to print and the number of pages gets us the price.

2. If the user at this time does not want to go forward with payment but wants to have it in his system so he can pay at a later time, then how does he do it? I know that it stays in the shopping cart. But the limitation is such that, a user cannot buy individual items that are in his shopping cart. He basically has to buy everything in it or delete the ones he does nto want at that time.

3. So I added Wish List. So that a user can add the item to the wish list. However, there is a problem that the products attributes cannot be retrieved.

4. This is the same problem with Quick Reorder. What if a user who has bought the item wants to order one more copy for their friends? The order cannot be reordered because right now, there is no way to identify the item. The quick reorder shows only the product but not the customized version of the product ( that can be identified by the job ID or a TITLE). It also does not bring back attributes. So this is useless because we cannot process any reorder without knowing the file name and we cannot charge the right amount without being able to get the right attributes.

5. The only thing I can see the the way the shopping cart side box works. I love it. The best thing is...

It stores the info that the user has uploaded and brings back all the attributes when we click on the name. Further, it stores each item.

I tried to make reorder work. Initially it was not bringing back the attributes of the product. But after I installed the Wish List module, it was bringing back one attribute - the Pages. And I dont know why it is bringing back the pages attribute. If I knew why, I would so the same thing to the jobID attribute too and ALLLLLL my problems will be solved just like that.

Now that i have not figured out how it is bringing back the pages info, I just went ahead and followed Ajeh's list of things to do and got the jobID to show up.

So now, if someone clicked on the item in quick reorder, all the important attributes will show up.

However, I now realized that the way items are listed in Quick Reorder just does not help me much if I have many orders of the same product, but customized versions of it.

So, after all the headbanging, beggind and soliciting I did, I am defeated.

I need commercial help. Even if I pay 500 dollars, no one has approached me to help.

What do I do?

At this time, i think it is just better to pay someone for this modification.

I give up.

I have tried many times to post for commercial help and did not receive any help.

So I checked online for PHP experts, PHP Guru, ZEN CART consultants, etc.

No one really helped.

I would add a detailed post to the Commercial Help Wanted on what you need done and see who responds to it ...