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
|