Yeah, you're on the right track.

I'd probably do the logic like

for each SKU in the catalog
    get the list of invoices that have this sku
    get list of SKUs in these invoices
    insert rows (sku1, sku2, count, last purchase)

Leon


_______________________________________________
FreeTrade-dev mailing list
[EMAIL PROTECTED]
http://share.whichever.com/mailman/listinfo/freetrade-dev

Reply via email to