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
Forum Search
Google Site Search
 All Forums
 Technical
 Advanced Tips and Tricks - NO QUESTIONS PLEASE
 CSV download - Add custom columns
Author « Topic »  

John M
Advanced Member

459 Posts

Pre-sales questions only
(More Details...)

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:

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

It is currently at [blue]line 274[/blue] for version 6.8.3

Add the line immediately after:

[red]if($customcolumnlist) $columnlist.=$customcolumnlist;[/red]

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

[red]$customcolumnlist=',pASIN,pBrand,pCurrency,pPartNumber,pModel,pConditionType,pTargetAudience,pRecommendedBrowseNode,pBulletPoint1,pBulletPoint2,pBulletPoint3,pSearchTerm1,pSearchTerm2,pSearchTerm3,pParent,pParentSKU,pRelationship,pVariationTheme,pCondition,pProductType,pManufacturer1,pProductIDType,pReorderLevel';[/red] 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

459 Posts

Pre-sales questions only
(More Details...)

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