Printable View
Is there a way to add a blank line after every entry? My client wants to sort by model number, then add all the quantities for each model number. A simple way to do this would be to add a blank line in the Excel spreadsheet, but that is tedious and it would be easier to have the module automatically add a blank line so an auto sum can be done in Excel without having to add the blank line manually. Any ideas?
is there a way to select particular orders with this? For example, if I want to export orders from a particular week, is that possible with this mod? If not, does anyone know of a mod that you can do that with?
I have the latest Orders Exporter. Where do I install the files?Quote:
Originally Posted by thematysek
Thanks!
It works great, thanks!!!
Hi
This is a great module, thanks.
But I really need to know how many of each product were ordered. It's nice that it has the line items for each product, but if someone ordered 3 of 1 thing and 5 of another, each product only gets 1 line and no info on item count.
Does anyone know how I can get the number of each product ordered?
Yes, the download is limited without quantity. Luckily, the file structure to generate the spreadsheet is very simple. Looking here:
you can see I added the quantity after the model number.PHP Code:'v_customers_country' => $iii++,
'v_customers_telephone' => $iii++,
'v_customers_email_address' => $iii++,
'v_products_model' => $iii++,
'v_products_quantity' => $iii++,
'v_products_name' => $iii++,
'v_products_options' => $iii++,
'v_products_options_values' => $iii++,
Then it should be added again like this:
It needs to be repeated for each type of output you want. I did it for the first selection.PHP Code:date_purchased as v_date_purchased,
orders_status_name as v_orders_status_name,
products_model as v_products_model,
products_quantity as v_products_quantity,
products_name as v_products_name,
products_options as v_products_options,
I'm going to look into other ways to manipulate the output like dropping the extra data and adding a line between orders.
Note also: the output is the Customer name and address. The file should also be changed to pull the delivery address data where needed (always in my case).
OK, I can't figure out how to drop a line break between orders. Any help would be appreciated.
I've downloaded this addon, and am excited to use it...but where the heck to I upload it to? I know it is probably easy, but I can't figure it out. Thanks!
In the readme file it sez:
++++
Upload the import script files and import_osc_configure.php to the same directory on your url.
Point your browser to one of the import scripts you want to run.
Example: http://www.yoursite.com/import_osc_customers.php
++++
It doesn't have to be in the root directory but in that example you would put those files in your root directory. Reminder: Do NOT leave them in there after you are done.
Jim