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
|