Include vendor names and product page links in csv download of orders from DIM?
ModernWizard
Posts: 904
Hi all, I know that DIM can provide a csv of ordered products, order dates, order numbers, and SKUs. Is there a way to add vendor names and/or to associate product page links to this data? Or is there a script that someone has created to scrape this data from the Daz website? Thanks in advance.
--MW

Comments
I don't believe DIM is scriptable so you'd be at the mercy of the Daz developers for that functionality.
I have tried to modifiy one of my Daz Studio scripts to pull out some of that info since you can get most of it. However, I don't think the order numbers make it into the CMS and so can't grab that. Also, it looks like the URLs that are available to Daz scripts look to be old/obsolete/broken - both by the url property and getUrl() method. They are in the format "http://www.daz3d.com/i/shop/itemdetails/?item=[ID]" so not only non-https but also all the ones I have tried lead to an Oops/404. They could be "fudgeable" by taking the name and url-ifying it which would not be perfect but should work for most products.
If you know your way around spreadsheets you can probably use a vlookup to join the data from the two sources together perhaps? Might be something to consider if no better options come along.
Thanks for your reply, SofaCitizen. I was hoping there was a way to automate this, but I am not savvy enough with spreadsheets to figure that out.
--MW
Well, a new day brings a new thought - I guess it should be possible to feed the DIM-export to a script in Daz Studio and then have that fill in the vendor info and spit out a modified version. Not sure if that would be classed as automated enough and still have the issue that the product URLs seem to be wrong/invalid.