Ecommerce software home
Shopping Cart Software Forum for Ecommerce Templates
 
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

Find us on Facebook Follow us on Twitter View our YouTube channel
Search our site
 All Forums
 Technical
 Advanced Tips and Tricks - NO QUESTIONS PLEASE
 CSV download - Add custom columns
Author « Topic »  

John M
Advanced Member

457 Posts

Posted - 01/22/2018 :  23:56:43  
Simple way to add your own custom columns that you may have added to the products table.

In the dumporders.php find the following line:

$columnlist.=',pStaticPage,pStockByOpts,pRecommend,pOrder,pSKU,pManufacturer,pSearchParams,pTitle,pMetaDesc,pStaticURL,pDescription,pMinQuant';

It is currently at line 274 for version 6.8.3

Add the line immediately after:

if($customcolumnlist) $columnlist.=$customcolumnlist;

In your includes file add the following line for the columns you want to add to the the CSV download file:

$customcolumnlist=',pASIN,pBrand,pCurrency,pPartNumber,pModel,pConditionType,pTargetAudience,pRecommendedBrowseNode,pBulletPoint1,pBulletPoint2,pBulletPoint3,pSearchTerm1,pSearchTerm2,pSearchTerm3,pParent,pParentSKU,pRelationship,pVariationTheme,pCondition,pProductType,pManufacturer1,pProductIDType,pReorderLevel'; This is an an example only of some extra columns required to synchronise with Amazon.

Now when you download an inventory file your own columns are also included.

John

John M
Advanced Member

457 Posts

Posted - 03/12/2018 :  03:26:14  
Please note:

The custom columns must exist in the database otherwise it will throw up an error.

John
  « Topic »  
Jump To:
Shopping Cart Software Forum for Ecommerce Templates © 2002-2022 ecommercetemplates.com
This page was generated in 0.02 seconds. Snitz Forums 2000