**Export Shipping Information 2
V1.5.6 2025-09-01
V1.5.5 2025-08-29
V1.5.4 2025-02-16
piloujp; OldNGrey (BMH)
Compatible with Zen Cart v1.5.8a, v2.0.1, v2.1.0 PHP 8.2 to PHP 8.4 http://www.zen-cart.com
http://www.zen-cart.com/forum/showthread.php?t=75406
This module enables you, from within the Admin, to export shipping information in various formats for orders placed.
What you do with that file is up to you. Some ideas: Drop shipping fulfillment, Analysis of data in Excel spreadsheets, bulk printing of labels, bulk printing of envelopes, etc., you get the idea.
1 If you have installed a previous version on zc1.5.8+, Copy the ../zc-plugins folder to your site Log into Admin > Modules > Plugin Manager locate Export Shipping & Order Information and installgo Admin > Modules > Plugin Manager uselook at your master copy and remove all of the files. Copy the ../zc-plugins folder to your site Log into Admin > Modules > Plugin Manager, locate 'Export Shipping & Order Information' click Un-Install and Un-Install again locate 'Export Shipping & Order Information' click Install and select v1.5.6 and click 'Install' again
2 New Install Copy the ../zc-plugins folder to your site Log into Admin > Modules > Plugin Manager locate 'Export Shipping & Order Information II' and install
- Enjoy!
BMH 2025-09-01 logic correction so one order per row + product details works as expected BMH 2025-08-28 bugfix - check subtotal piloujp 2025-02-16 Replaced all hard coded language strings by constants for internationalization Auto install SQL query BMH 2024-11-30 check each optional array key eg tickboxes; tidy up html; correct bugfix; check for order with no products (products previously deleted); fix headers BMH 2024-11-19 check each optional array key eg tickboxes; tidy up html BMH 2024-03-17 remove ASC from all group by statements issue #4 resolved add 4 names option; added extra group by fields to avoid group by error when SQL mode 'ONLY_FULL_GROUP_BY' is set add space before GROUP BY mod for group by and distinct for one order per row; improve parsing of names to include unicode chars; improve opr to output correct number of columns admin head update
BMH 2023-12-21 set version to 1.5.0 for zc 1.5.7 old files structure maintained for zc 1.5.8+ use the zc_plugins structure
BMH 2023-09-28 set version to 1.4.2 use case statements when parsing name to break up into first middle last
BMH 2023-08-29 set version to 1.4.1d corrected shipping method heading clean product name if double quotes included as per abbreviation for inch
BMH 2023-06-17 ln50 set version to 1.4.1c discounts now include all (ot_coupon' , 'ot_custom', 'ot_group_pricing', 'ot_payment_type' , 'ot_paymentmodule) summed and made negative DISTINCT values only returned for when multiple discounts applied moved shipping total heading and values to follow after subtotal headings and values line tax is now calculated
BMH 2023-03-03 admin\shipping_export.php ln50 set version to 1.4.1a reordered data output to match reconciliation spreadsheet Order ID, Customer Email, First Name, Last Name, Company, Delivery Street, Delivery Suburb, Delivery City, Delivery State, Delivery Post Code, Delivery Country, Ship Dest Type, Order Date, Product Qty, Product Model, Product Name, Products Price, Product Attributes, Line cost, Line tax, Shipping Total, Order Subtotal, Order Discount, Order Total, Order Tax, Payment Method calculated value line cost, line tax is a filler but not calculated defaulted most commonly used checkboxes to "Checked" reordered options to most commonly used to suit reconciliation spreadsheet
BMH 2023-01-15
admin\shipping_export.php
ln12 set version to 1.4.1
ln668 $success_message not set on initial load
ln84, 87, 96, 104, 243, 246, 249, 283, 936, 938, 940, 942, 944 ,946, 949, 951, 953, 955, 957, 959, 961, 968 check var isset - for initial load
ln374 include other discount types - only picks up first one
\admin\includes\languages\extra_definitions
create zc158 lang file lang-shipping_export.php
Run In Test Mode Export First and Last Name into Separate Fields. Include Header Row In Export Any Order Status Include orders already downloaded in export. 1 Product per row Shipping Total Order Total Order Date Order Tax Amount Order Subtotal Order Discount Payment Method Full Product Details *