importing data into ZenCart - Revision history

Woozle: /* custom_dhtml.php */ replaced missing end-php tag

2007-05-15T14:12:45Z

custom_dhtml.php: replaced missing end-php tag

← Older revision		Revision as of 14:12, 15 May 2007
Line 36:		Line 36:
	echo zen_draw_admin_box($za_heading, $za_contents);		echo zen_draw_admin_box($za_heading, $za_contents);
	?>		?>
	<!-- end of drop-down //-->		<!-- end of drop-down //--></php>
	"Jubilee Custom Functions" can be replaced by whatever text seems appropriate; "Jubilee" was part of the name of the store I was setting up, and I wanted to make it clear to the owner that this was the menu entry I had written for him.		"Jubilee Custom Functions" can be replaced by whatever text seems appropriate; "Jubilee" was part of the name of the store I was setting up, and I wanted to make it clear to the owner that this was the menu entry I had written for him.
	===custom_menu.php===		===custom_menu.php===
Line 45:		Line 45:
	require(DIR_WS_BOXES . 'custom_dhtml.php');</php>		require(DIR_WS_BOXES . 'custom_dhtml.php');</php>
	Removing extras_dhtml.php is optional; the store I was setting up had no use for it.		Removing extras_dhtml.php is optional; the store I was setting up had no use for it.

	===new tables===		===new tables===
	So far, I haven't needed to use the new table names in more than one file; if I do, I'll need to move the defines from '''{{faint\|$zc}}/admin/custom_menu.php''' to '''{{faint\|$zc}}/includes/database_tables.php'''		So far, I haven't needed to use the new table names in more than one file; if I do, I'll need to move the defines from '''{{faint\|$zc}}/admin/custom_menu.php''' to '''{{faint\|$zc}}/includes/database_tables.php'''

Woozle: /* Patches */ update: basic image management working

2007-05-15T14:11:37Z

Patches: update: basic image management working

← Older revision		Revision as of 14:11, 15 May 2007
Line 4:		Line 4:
	[[ZenCart]], as of this writing, has no facility for importing business data for other applications. Due to ZenCart's [[open source]] nature, however, it is not difficult to write such a routine and add it to the menu of available functions in the Administration section. The necessary particulars are not very well documented yet, so this page will be a collection point for that information.		[[ZenCart]], as of this writing, has no facility for importing business data for other applications. Due to ZenCart's [[open source]] nature, however, it is not difficult to write such a routine and add it to the menu of available functions in the Administration section. The necessary particulars are not very well documented yet, so this page will be a collection point for that information.
	==Patches==		==Patches==
	~~'''''Note''': I am currently in the process of adding a~~ bulk~~-image~~-upload ~~capability; the code presented here works for bulk data entry~~, ~~but the image upload capability is incomplete.~~ -~~-[[User:Woozle\|Woozle]] 15:03, 10 March 2007~~ (~~EST~~)''		Some features are still stubbed, but you can bulk-upload images and then assign or delete them individually. Some functions use wiki access, which can be replaced with hard-coded HTML (need to document this).
	===custom_dhtml.php===		===custom_dhtml.php===
	* '''new file''': {{faint\|$zc}}/admin/includes/boxes/custom_dhtml.php		* '''new file''': {{faint\|$zc}}/admin/includes/boxes/custom_dhtml.php
Line 20:		Line 20:

	define('CUSTOM_MENU_MODULE', 'custom_menu');		define('CUSTOM_MENU_MODULE', 'custom_menu');
			define('CUSTOM_MODULE_SET_PROD_ENTRY','bulk_prod_entry');
			define('CUSTOM_MODULE_SET_BULK_UPLOAD','bulk_img_upload');
			define('CUSTOM_MODULE_SET_BULK_ASSIGN','bulk_img_assign');

	$za_contents = array();		$za_contents = array();
Line 25:		Line 28:
	// 2006-09-17 (Wzl) this could ultimately use language defines, but for now I am hard-coding the text		// 2006-09-17 (Wzl) this could ultimately use language defines, but for now I am hard-coding the text
	$za_heading = array('text' => 'Jubilee Custom Functions', 'link' => zen_href_link(CUSTOM_MENU_MODULE, '', 'NONSSL'));		$za_heading = array('text' => 'Jubilee Custom Functions', 'link' => zen_href_link(CUSTOM_MENU_MODULE, '', 'NONSSL'));
	$za_contents[] = array('text' => 'Bulk product entry', 'link' => zen_href_link(CUSTOM_MENU_MODULE, 'set=~~prod_entry~~', 'NONSSL'));		$za_contents[] = array('text' => 'Bulk product entry', 'link' => zen_href_link(CUSTOM_MENU_MODULE, 'set=bulk_prod_entry', 'NONSSL'));
			$za_contents[] = array('text' => 'Bulk image upload', 'link' => zen_href_link(CUSTOM_MENU_MODULE, 'set=bulk_img_upload', 'NONSSL'));
			$za_contents[] = array('text' => 'Bulk image assign/delete', 'link' => zen_href_link(CUSTOM_MENU_MODULE, 'set=bulk_img_assign', 'NONSSL'));
	?>		?>
	<!-- drop-down //-->		<!-- drop-down //-->
Line 31:		Line 36:
	echo zen_draw_admin_box($za_heading, $za_contents);		echo zen_draw_admin_box($za_heading, $za_contents);
	?>		?>
	<!-- end of drop-down //--~~></php~~>		<!-- end of drop-down //-->
	"Jubilee Custom Functions" can be replaced by whatever text seems appropriate; "Jubilee" was part of the name of the store I was setting up, and I wanted to make it clear to the owner that this was the menu entry I had written for him.		"Jubilee Custom Functions" can be replaced by whatever text seems appropriate; "Jubilee" was part of the name of the store I was setting up, and I wanted to make it clear to the owner that this was the menu entry I had written for him.
	===custom_menu.php===		===custom_menu.php===

Woozle: /* new tables */ .match->.request ("match" seems to be a keyword)

2007-03-29T22:39:16Z

new tables: .match->.request ("match" seems to be a keyword)

← Older revision		Revision as of 22:39, 29 March 2007
Line 79:		Line 79:
	`size_x` int(11) DEFAULT NULL COMMENT 'pixel width of image',		`size_x` int(11) DEFAULT NULL COMMENT 'pixel width of image',
	`size_y` int(11) DEFAULT NULL COMMENT 'pixel height of image',		`size_y` int(11) DEFAULT NULL COMMENT 'pixel height of image',
	`~~match~~` varchar(255) NOT NULL COMMENT 'resizing request to match, for quick searching (id_upload + x + y)',		`request` varchar(255) NOT NULL COMMENT 'resizing request to match, for quick searching (id_upload + x + y)',
	`when_made` datetime NOT NULL COMMENT 'when thumbnail was generated'		`when_made` datetime NOT NULL COMMENT 'when thumbnail was generated'
	) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='record of thumbnails already created; used for thumbnail caching';</sql>		) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='record of thumbnails already created; used for thumbnail caching';</sql>

Woozle: /* new tables */ custom_upload_thumbs.match (removed .geometry); note about optimization

2007-03-29T22:29:31Z

new tables: custom_upload_thumbs.match (removed .geometry); note about optimization

← Older revision		Revision as of 22:29, 29 March 2007
Line 79:		Line 79:
	`size_x` int(11) DEFAULT NULL COMMENT 'pixel width of image',		`size_x` int(11) DEFAULT NULL COMMENT 'pixel width of image',
	`size_y` int(11) DEFAULT NULL COMMENT 'pixel height of image',		`size_y` int(11) DEFAULT NULL COMMENT 'pixel height of image',
	`~~geometry~~` varchar(255) NOT NULL COMMENT '~~geometry options used~~ to ~~generate thumb~~ (~~used to find thumbs already generated~~)',		`match` varchar(255) NOT NULL COMMENT 'resizing request to match, for quick searching (id_upload + x + y)',
	`when_made` datetime NOT NULL COMMENT 'when thumbnail was generated'		`when_made` datetime NOT NULL COMMENT 'when thumbnail was generated'
	) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='record of thumbnails already created; used for thumbnail caching';</sql>		) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='record of thumbnails already created; used for thumbnail caching';</sql>
			'''Note''': a more ideal optimization would have a separate table for requests; this version will sometimes unnecessarily recreate thumbnail files, though at least it won't store more thumbnail files than necessary.

	===new folders===		===new folders===

Woozle: /* new tables */ geometry revision (changed how it is handled)

2007-03-29T17:12:54Z

new tables: geometry revision (changed how it is handled)

← Older revision		Revision as of 17:12, 29 March 2007
Line 66:		Line 66:
	`id_upload` int(11) NOT NULL COMMENT 'custom_uploads.id',		`id_upload` int(11) NOT NULL COMMENT 'custom_uploads.id',
	`filespec` varchar(255) NOT NULL COMMENT 'relative filespec of image file',		`filespec` varchar(255) NOT NULL COMMENT 'relative filespec of image file',
			`size_x` int(11) DEFAULT NULL COMMENT 'pixel width of image',
			`size_y` int(11) DEFAULT NULL COMMENT 'pixel height of image',
	`id_prod` int(11) default NULL COMMENT 'products.products_id - product to which this image was assigned',		`id_prod` int(11) default NULL COMMENT 'products.products_id - product to which this image was assigned',
	`when_deleted` datetime default NULL COMMENT 'if not null, this file has been deleted',		`when_deleted` datetime default NULL COMMENT 'if not null, this file has been deleted',
Line 75:		Line 77:
	`id_file` int(11) NOT NULL COMMENT 'custom_upload_files.id',		`id_file` int(11) NOT NULL COMMENT 'custom_upload_files.id',
	`filename` varchar(255) NOT NULL COMMENT 'filename.ext inside thumbs folder; generally "id-geometry.ext"',		`filename` varchar(255) NOT NULL COMMENT 'filename.ext inside thumbs folder; generally "id-geometry.ext"',
			`size_x` int(11) DEFAULT NULL COMMENT 'pixel width of image',
			`size_y` int(11) DEFAULT NULL COMMENT 'pixel height of image',
	`geometry` varchar(255) NOT NULL COMMENT 'geometry options used to generate thumb (used to find thumbs already generated)',		`geometry` varchar(255) NOT NULL COMMENT 'geometry options used to generate thumb (used to find thumbs already generated)',
	`when_made` datetime NOT NULL COMMENT 'when thumbnail was generated'		`when_made` datetime NOT NULL COMMENT 'when thumbnail was generated'

Woozle: /* new tables */ table for tracking thumbnails

2007-03-28T21:33:09Z

new tables: table for tracking thumbnails

← Older revision		Revision as of 21:33, 28 March 2007
Line 69:		Line 69:
	`when_deleted` datetime default NULL COMMENT 'if not null, this file has been deleted',		`when_deleted` datetime default NULL COMMENT 'if not null, this file has been deleted',
	`who_deleted` int(11) default NULL COMMENT 'admin.admin_id of who did the deletion'		`who_deleted` int(11) default NULL COMMENT 'admin.admin_id of who did the deletion'
	) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='detail table for custom_uploads: one record per file';</sql>		) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='detail table for custom_uploads: one record per file'

			CREATE TABLE `custom_upload_thumbs` (
			`id` int(11) NOT NULL key auto_increment,
			`id_file` int(11) NOT NULL COMMENT 'custom_upload_files.id',
			`filename` varchar(255) NOT NULL COMMENT 'filename.ext inside thumbs folder; generally "id-geometry.ext"',
			`geometry` varchar(255) NOT NULL COMMENT 'geometry options used to generate thumb (used to find thumbs already generated)',
			`when_made` datetime NOT NULL COMMENT 'when thumbnail was generated'
			) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='record of thumbnails already created; used for thumbnail caching';</sql>

	===new folders===		===new folders===

Woozle: /* new folder */ thumbs

2007-03-26T17:44:58Z

new folder: thumbs

← Older revision		Revision as of 17:44, 26 March 2007
Line 71:		Line 71:
	) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='detail table for custom_uploads: one record per file';</sql>		) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='detail table for custom_uploads: one record per file';</sql>

	===new ~~folder~~===		===new folders===
	You will need to create the ~~'''{{faint\|$zc}}/images/bulk''' folder~~ and give it universal read/write permission (same as the images folder) in order for bulk uploads to work.		You will need to create the following folders and give them universal read/write permission (same as the images folder) in order for bulk uploads to work.
			* '''{{faint\|$zc}}/images/bulk'''
			* '''{{faint\|$zc}}/images/thumbs'''

	==Reference==		==Reference==
	* ZenCart wiki: [[zencartwiki:DB - Importing products\|DB - Importing products]]		* ZenCart wiki: [[zencartwiki:DB - Importing products\|DB - Importing products]]

Woozle: $zc prefix for (I hope) clarity

2007-03-16T11:18:07Z

$zc prefix for (I hope) clarity

← Older revision		Revision as of 11:18, 16 March 2007
Line 6:		Line 6:
	'''''Note''': I am currently in the process of adding a bulk-image-upload capability; the code presented here works for bulk data entry, but the image upload capability is incomplete. --[[User:Woozle\|Woozle]] 15:03, 10 March 2007 (EST)''		'''''Note''': I am currently in the process of adding a bulk-image-upload capability; the code presented here works for bulk data entry, but the image upload capability is incomplete. --[[User:Woozle\|Woozle]] 15:03, 10 March 2007 (EST)''
	===custom_dhtml.php===		===custom_dhtml.php===
	* '''new file''': admin/includes/boxes/custom_dhtml.php		* '''new file''': {{faint\|$zc}}/admin/includes/boxes/custom_dhtml.php
	<php><?php		<php><?php
	/*		/*
Line 36:		Line 36:
	* '''new file''': [[ZenCart data import - admin/custom_menu.php]]		* '''new file''': [[ZenCart data import - admin/custom_menu.php]]
	===header_navigation.php===		===header_navigation.php===
	* '''file edit''': admin/includes/header_navigation.php		* '''file edit''': {{faint\|$zc}}/admin/includes/header_navigation.php
	<php>// require(DIR_WS_BOXES . 'extras_dhtml.php');		<php>// require(DIR_WS_BOXES . 'extras_dhtml.php');
	require(DIR_WS_BOXES . 'custom_dhtml.php');</php>		require(DIR_WS_BOXES . 'custom_dhtml.php');</php>
	Removing extras_dhtml.php is optional; the store I was setting up had no use for it.		Removing extras_dhtml.php is optional; the store I was setting up had no use for it.
	===new tables===		===new tables===
	So far, I haven't needed to use the new table names in more than one file; if I do, I'll need to move the defines from '''admin/custom_menu.php''' to '''includes/database_tables.php'''		So far, I haven't needed to use the new table names in more than one file; if I do, I'll need to move the defines from '''{{faint\|$zc}}/admin/custom_menu.php''' to '''{{faint\|$zc}}/includes/database_tables.php'''
	* '''new tables''':		* '''new tables''':
	<sql>CREATE TABLE `custom_import_mfgrs` (		<sql>CREATE TABLE `custom_import_mfgrs` (

Woozle: /* new tables */ deletion management fields

2007-03-16T11:16:07Z

new tables: deletion management fields

← Older revision		Revision as of 11:16, 16 March 2007
Line 66:		Line 66:
	`id_upload` int(11) NOT NULL COMMENT 'custom_uploads.id',		`id_upload` int(11) NOT NULL COMMENT 'custom_uploads.id',
	`filespec` varchar(255) NOT NULL COMMENT 'relative filespec of image file',		`filespec` varchar(255) NOT NULL COMMENT 'relative filespec of image file',
	`id_prod` int(11) default NULL COMMENT 'products.products_id - product to which this image was assigned'		`id_prod` int(11) default NULL COMMENT 'products.products_id - product to which this image was assigned',
			`when_deleted` datetime default NULL COMMENT 'if not null, this file has been deleted',
			`who_deleted` int(11) default NULL COMMENT 'admin.admin_id of who did the deletion'
	) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='detail table for custom_uploads: one record per file';</sql>		) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='detail table for custom_uploads: one record per file';</sql>

	===new folder===		===new folder===
	You will need to create the '''{{faint\|$zc}}/images/bulk''' folder and give it universal read/write permission (same as the images folder) in order for bulk uploads to work.		You will need to create the '''{{faint\|$zc}}/images/bulk''' folder and give it universal read/write permission (same as the images folder) in order for bulk uploads to work.

24.136.238.245: /* new tables */ new folder

2007-03-13T11:25:52Z

new tables: new folder

← Older revision		Revision as of 11:25, 13 March 2007
Line 68:		Line 68:
	`id_prod` int(11) default NULL COMMENT 'products.products_id - product to which this image was assigned'		`id_prod` int(11) default NULL COMMENT 'products.products_id - product to which this image was assigned'
	) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='detail table for custom_uploads: one record per file';</sql>		) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='detail table for custom_uploads: one record per file';</sql>
			===new folder===
			You will need to create the '''{{faint\|$zc}}/images/bulk''' folder and give it universal read/write permission (same as the images folder) in order for bulk uploads to work.

	==Reference==		==Reference==
	* ZenCart wiki: [[zencartwiki:DB - Importing products\|DB - Importing products]]		* ZenCart wiki: [[zencartwiki:DB - Importing products\|DB - Importing products]]