Query to optimize warehouse locations

[Sunshack]

Hi!


To provide you with some context; i work for a warehouse that distribute car parts. Certain car parts are often sold at the same time since they fit a certain vehicle, and they're often changed at the same service interval. For example: oil filters+oil are often sold at the same time.. Therefore it would be timesaving to make sure these parts are stored at a location close to each other.

I have a table containing order number and item number. I need to identify which item combinations that are often sold at the same time.
The table contains about 3 million posts, and the orders vary from 2 rows up to about 10-20.
Is there a way i can work with this information to give me a list of the items that are often sold at the same time?

Appreciate all help I can get!

[ranman256]

i assume you have a tOrder table and its subtable tOrderDetails table?
can you sort the

tOrderDetails.Product# on the tOrder.DateSold field?

[Sunshack]

Yes, I have all sorts of tables available And yes, sorting them by date is no problem!

[orange]

Can you tell us more about your final objective or goal?
Your thread title indicates
optimize warehouse locations, but it seems you want to know more about the combination of items sold at same time.

[Sunshack]

Yeah, like i tried to explain in the first post; the objective is to identify what products that are often sold on the same order (and therefore picked simultaneously by our warehouse crew). When we have identified the items that are frequently ordered at the same time, we can physically move those items closer to each other, so that the person that picks the order can save time because he/she doesnt have to walk as far between the items (we have a big warehouse, hehe)

I hope this helps clarify my end goal!