Amazon Shop Admin Panel

get_js_menu(0); ?> Amazon Shop Admin Panel - SQL Insert

Category Import

Here are a few notes on this script and some requirements of the text file you are importing:

Use this script at your own risk!
Backup your database.
Do some test importing before running on your live site. This script is not very forgiving and may import bad records if the text file is not setup right.
Text files may need to be split. Larger files may get a "max execution time reached" PHP error. I have imported 400k files without a problem but it all depends on your server speed.
Script tested on version 5.0.5 of Amazon Shop
Text file must contain nodes from only one mode.
For some reason Browse Nodes does not seem to match 100% the node structure from Amazon.
If Parent Node does not exist in database, script will assume the node is a top level node of your store.
Below are the settings of the text file you need to set when you download your node list from www.BrowseNodes.com.

Download (can pick either)	Just This Node's Immediate Children All of This Node's Children
AWS Version	Return Mode for Each Node (AWS 3)
Format	Title\|Parent\|Node
Null Parent	Use "0" for null Parent Node
Delimiter	Use "\|" to Delimit Fields
File Format (End-of-Line)	DOS/Windows Format (CrLf)