Hi,

I want to download some inventory products and add the URL to the rows. I have Navicat MySQL app but I cannot seem to find the URL pointers in the database. Can anyone help me find them?

Thanks,
Brad

Are you looking to create static pages? That's the only reason you would want to fill in the URL column really.
When you download the file, all of the available columns should be in the csv file.
Have you taken a look?

Thanks,
David

Hi David,

Not static pages. I want to take some inventory products and upload to Amazon via their upload file. The person doing the work needs a URL to get more information to populate the spreadsheet.

It's just for reference instead of having to manually insert a URL for each row.

The URL is dynamic and generated from the either the pID or the pName depending on your config choices in the includes file.

You need to be aware of these parameters which may or may not be part of the URL:

$orstoreurlssl
$usepnamefordetaillinks
$seodetailurls
$detlinkspacechar
$seoprodurlpattern

If you have [green]already set a static url for every product [/green] then it should be part of the download unless you are on an old version before it came about.

If that is the case the you can add this to the includes file:

[red]$customcolumnlist=',pStaticURL';[/red]

Then in the dumporders.php where it says: [blue]$columnlist.=',pLongDescription';[/blue]

Add a line just below it with this : [red]$columnlist.=$customcolumnlist;[/red]

That way you can add any column (or columns) of your choice from the products table to the download, which is a nice feature and something we do anyway.

John