Modify Magento default export Customs feature

The export function of the Magento 1.x makes it easy to derive data from products and customs, but there are several disadvantages (or inconvenient) places:

1. Exported by default. The CSV file is encoded in UTF-8 format, and the default encoding format for MS Excle is Unicode, so the exported. CSV file opened directly in Excle Chinese will be garbled, garbled not only will cause Chinese cells can not read, and will affect other cells, will make other cells dislocation

2. Lack of is_subscribed information. Is_subscribed is used to identify whether a custom is willing to receive a subscription message (Newsletter), this information is often used, but it is unfortunate that export can not be exported is_subscribed information, because Is_ The subscribed information is saved in the newsletter table and is not stored directly in the custom related table.

3. Although the Export page can choose to skip some unwanted information items, there are some unwanted information items listed, so some unwanted information cannot be filtered out.

The 3 deficiencies listed above:

1th of which can be resolved through the file transcoding, do not need to modify code, and modify code is more complex, because it involves the generation. CVS file. The specific practice is to open the download with txt. CVS file, and then choose "Save as", under the "Save as" dialog box, there will be a drop-down menu that chooses the encoding format, change the encoding format from UTF-8 to Unicode, and then save to solve the garbled problem.

2nd and 3rd are required to modify code to resolve. The steps are as follows:

(not to be continued)

Modify Magento default export Customs feature