Page 47 of 50 FirstFirst ... 374546474849 ... LastLast
Results 461 to 470 of 497
  1. #461
    Join Date
    Apr 2008
    Location
    Qld, Australia
    Posts
    250
    Plugin Contributions
    6

    Default Re: Export Shipping & Order Information

    Version number in the main file is set back at 1.3.2 it should be 1.3.5 by now

  2. #462
    Join Date
    Mar 2016
    Location
    Marietta GA
    Posts
    70
    Plugin Contributions
    0

    Default Re: Export Shipping & Order Information

    Hello, I'm using v 1.3.3 of the plug-in. This is a fantastic tool for doing all kinds of free-style analysis of orders. Thanks to all who created it and contributed to it. I'd like to learn how to extend it just a bit. In the Select File Layout to Export section, when I select the " 1 Product per row" radio, I would like to include the Category of the product in the CSV. Can someone tell me what file(s) I need to hack up? I'm no php dev, but I think I can follow existing code, and do this myself, given a little lead. I'll post my code once I nut it out, and if swguy thinks it's worthwhile, you can publish an update to the plugin.

    Thanks for the help!

  3. #463
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,623
    Plugin Contributions
    123

    Default Re: Export Shipping & Order Information

    Thanks for your contribution!
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  4. #464
    Join Date
    Mar 2016
    Location
    Marietta GA
    Posts
    70
    Plugin Contributions
    0

    Default Re: Export Shipping & Order Information

    Quote Originally Posted by swguy View Post
    Thanks for your contribution!
    Well, you're welcome swguy, but I haven't contributed anything yet, , but I will.

    So I downloaded the latest ver and took a look at the files, and surprisingly there are only four .php's It looks like /admin/shipping_export.php is the file to tweak. It looks like lines 73-75 is where the solution is, and I'd stick the category name at the bold.

    if ($_POST['filelayout'] == 2) { // 1 Product Per row RADIO

    $order_info = "SELECT o.orders_id, customers_email_address, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, shipping_method, customers_telephone, order_total, op.products_model, products_name, categories_name, op.products_price, final_price, op.products_quantity, date_purchased, ot.value, orders_products_id, order_tax, o.orders_status, o.payment_method";

    Simple enought, BUT . . .

    I said I'm not a PHP dev, but I now see ya gotta know your way around mysql, too. (Note the twitch, ha-ha) I do know that anywere you have a "SELECT" you have to have a matching FROM which I see a little further down. Got no idea how to insert CATEGORIES_DESCRIPTIONS.categories_name into this:


    $order_info = $order_info . " FROM (" . TABLE_ORDERS . " o LEFT JOIN " . TABLE_ORDERS_PRODUCTS . " op ON o.orders_id = op.orders_id), " . TABLE_ORDERS_TOTAL . " ot";
    if ($_POST['iso_country2_code'] == 1 || $_POST['iso_country3_code'] == 1) {
    $order_info = $order_info . ", " . TABLE_COUNTRIES . " cc";
    };


    Anyone?
    Last edited by greg_beyer; 8 Feb 2021 at 05:45 PM.

  5. #465
    Join Date
    Mar 2016
    Location
    Marietta GA
    Posts
    70
    Plugin Contributions
    0

    Default Re: Export Shipping & Order Information

    Well, simply adding categories_name to the SELECT string does not work, I get a column not found error. That would be because the FROM statement does not include the CATEGORIES_DESCRIPTIONS table, categories_name column.

    $order_info = $order_info . " FROM (" . TABLE_ORDERS . " o LEFT JOIN " . TABLE_ORDERS_PRODUCTS . " op ON o.orders_id = op.orders_id), " . TABLE_ORDERS_TOTAL . " ot";

    I've pasted the original select / from statement in my my phpmyadmin sql window and cleaned out the PHP coding, and tried about 30 different combos of sql runs but cannot get just this original query to run. Do not find the "o", "op" and "ot" syntax in mysql documentation, so don't know their significance.

    Much less do I know how to add the CATEGORIES_DESCRIPTION.categories_name to the FROM. So I guess hacking this myself is beyond my capabilities. Swguy, I'd sure appreciate your help in getting the FROM statement right. Then I think the adding categories_name to the select will work.

    Hadda at least try. Thanks for any help.

  6. #466
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Export Shipping & Order Information

    No, you can't retrieve category information from that table, because that table doesn't contain those details.

    In fact, none of the "order"-related tables contain anything related to the category in which a product existed at any point in time.

    If the product actually still exists in the database, then you could manually query for the "master" category ID that the product belongs to, but you can't get what "linked" category the customer might have been shopping in when adding the item to their cart.
    To do that, you could use:
    zen_get_category_name(zen_get_products_category_id($products_id)) ... but you'll have to also get $products_id when querying the orders_products table by adding products_id to the appropriate query.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  7. #467
    Join Date
    Mar 2006
    Posts
    477
    Plugin Contributions
    0

    Default Re: Export Shipping & Order Information

    Is there a way i can set it up so that i don't have to go threw and pick each box every time? If so how can i do that?
    We sell ATV, Dirtbike, Streetbike, Snowmobile, Watercraft & Custom stickers & Banners. Check us out www.AD-DiscountPerformance.com

  8. #468
    Join Date
    Mar 2006
    Posts
    477
    Plugin Contributions
    0

    Default Re: Export Shipping & Order Information

    Quote Originally Posted by Dashizna View Post
    Is there a way i can set it up so that i don't have to go threw and pick each box every time? If so how can i do that?
    Anyone?
    We sell ATV, Dirtbike, Streetbike, Snowmobile, Watercraft & Custom stickers & Banners. Check us out www.AD-DiscountPerformance.com

  9. #469
    Join Date
    Mar 2005
    Location
    United Kingdom
    Posts
    608
    Plugin Contributions
    0

    Default Re: Export Shipping & Order Information

    From memory it is covered in this thread. Run a search for defaults.

  10. #470
    Join Date
    Aug 2008
    Location
    Sydney Australia
    Posts
    485
    Plugin Contributions
    0

    Default Re: Export Shipping & Order Information

    Hi All,

    Just installed Export shipping / order information and it works a treat but what I want to do is add some more fields for it to download which are:

    Product shipping weight

    Product length

    Product width

    Product height

    If anyone could assist on where and what files I need to adjust it would be a great help.

 

 
Page 47 of 50 FirstFirst ... 374546474849 ... LastLast

Similar Threads

  1. Export Shipping+Order Information plugin not exporting some orders
    By woemlavy in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 22 Mar 2013, 02:01 PM
  2. v138a Trouble Installing Export Shipping+Order Information
    By scripto in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 16 Jan 2013, 11:36 PM
  3. Export Shipping/Order Information - dump down to 2 sheets or XML
    By sbbemn in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 4 Oct 2012, 05:37 PM
  4. Export Shipping / Order Information
    By digruk in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 28 Oct 2011, 08:25 PM
  5. Export Shipping Order Information doesn't include downloadable products?
    By rcaroe in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 31 Jul 2010, 05:14 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR