Export Shipping & Order Information

[chibipaw]

Uploaded a version to work with Php 7.x

Version is now 1.3.4

[linuxguy2]

Indispensable Plugin!

My client wants to NOT see all the RSS stuff and I don't want it running in the background.
How do I gracefully remove all the RSS feed stuff.

I butchered the code on a previous install BUT I don't want it running in the background.

Thanks, Lucien

[linuxguy2]

I'm using the checkbox option in the attributes

When downloading CSV file I want to make a separate row for each products WITH the size attribute appended.
Is this possible in exporter or would this require a ZC code change when generating the order?

THIS:
Product Name
4400407S
4400407L

NOT THIS:
Product Name Product Model Product Attributes
4400407 6003 Size: S | Size: L |

[boxcar]

Package in zen repository, export_shipping_information_V1.3.5.zip, file admin/shipping_export.php has version number 1.3.2 (it wasn't updated) so wrong version number shows in admin interface.

[swguy]

Updated to remove marketing information, clean out dead code and reformat.

[OldNGrey]

The variable "TEXT_PREVIOUS_EXPORTS" is defined twice in \admin\includes\languages\english\extra_definitions\shipping_export.php
lines 32 and 33

[linuxguy2]

PHP 7.1
zen-cart-v1.5.6a-01042019
[CloneClassic Template]
one_page_checkout-2.0.5
extra_field_on_customer_sign_up_0
EasyPopulate-4.master-ZC
export_shipping_information_V1.3.5
Several core mods.

The issue I'm having with ESI is when the Company name has a comma in it (My Big Company, Inc.)
As expected the CSV file sees the comma as an additional delimiter (See attached example)
Is it possible to delete the commas in the "Customer" column during exporting.
OR is there some other option to eliminate the comma.

Thank You for your time!

[balihr]

The issue I'm having with ESI is when the Company name has a comma in it (My Big Company, Inc.)
As expected the CSV file sees the comma as an additional delimiter (See attached example)
Is it possible to delete the commas in the "Customer" column during exporting.
OR is there some other option to eliminate the comma.

Thank You for your time!

I think your problem is Excel, not the CSV file. Open the CSV file with Notepad and see how it looks. If the data is something like "My Big Company, Inc.","12670","L-01"... then it's definitely Excel causing headaches. If exported file does have correct field delimiters and fields are properly enclosed with double-quotes, the results ARE valid, and it's just Excel being Excel. I find Excel almost impossible to use with CSV files and have become a huge fan of OpenOffice Calc (plus it's free).

As a workaround, you can change the delimiter to a semicolon - it's a trick I used before OpenOffice Calc. Just edit shipping_export.php and change line 36 from

$FIELDSEPARATOR = ',';

to

$FIELDSEPARATOR = ';';

and when you open the file in Excel, you'll have to set your custom delimiter when you choose to convert data to columns.

[delia]

if you are drop shipping to different providers, the manufacturer may be the most important part of the export. Has anyone added that in at any point? I might be able to figure out how but I'm a little surprised this isn't in there.

[Dashizna]

So far this module is great. i just want to ask if i can setup a way to export the billing address for customers? also if there is a way to set all the boxes up so that i don't have to do it every time i export because we use the same method every time.

Thanks