=============================================================================================================================
=============================================================================================================================
--- Attributes
INSERT INTO sunil_linensanddown.zsk_attribute_value
(
	SELECT 
	AttributeValueID,
	AttributeID,
	AttributeValue,
	AttributeValue as AttributeLine,
	'' as ColorCode,
	'' as Image,
	Active,
	Position,
	'' as FeedID,
	'' as FeedType,
	'' as DumpData,
	CreatedDate
	FROM  sunil_linensanddown_old.zsk_attribute_value 
);

--- Groups
INSERT INTO sunil_linensanddown.zsk_group_value
(
	SELECT 
	NULL as GroupValueID,
	'1' as GroupID ,
	attributeName as GroupValue,
	'1' as Active,
	'1' as Position,
	now() as CreatedDate
	FROM  sunil_linensanddown_old.attributes  GROUP BY attributeName
);


SELECT DISTINCT attributeName FROM `attributes` 
ORDER BY `attributes`.`attributeName` ASC


 
--- Categories 
SELECT group_concat(column_name order by ordinal_position) from information_schema.columns where 
table_schema = 'sunil_linensanddown' and table_name = 'zsk_category';

INSERT INTO sunil_linensanddown.zsk_category
(
	SELECT 
	CategoryID,
	CategoryName,
	CategoryTitle,
	'' as CategoryCode,
	'' as CategoryPassword,
	Description,
	CategoryLine as FullDescription,
	Image,
	Active,
	Featured,
	'0' as TopMenu,
	Position,
	UpperBanner1,
	Template,
	ParentID,
	'0' as MegaMenu,
	'0' as MegaMenuCols,
	'' as MegaMenuDescription,
	'0' as ProductSpecific,
	'' as ProductIDs,
	'' as MegaMenuProductTitle,
	'' as FeaturedProductIDs,
	'' as FeedID,
	'' as FeedType,
	'' as DumpData,
	CreatedDate
	FROM  sunil_linensanddown_old.zsk_category 
		
);

INSERT INTO sunil_linensanddown.zsk_seo
(
	SELECT NULL AS URLID,
		   LOWER(REPLACE(REPLACE(REPLACE(URLName,'&',''),' ','-'),'--','-')) as URLName,
		   MetaTitle,
		   MetaKeyword,
		   MetaDescription,
		   RedirectEnabled,
		   RedirectURL,
		   'catalog_category' as MCode,
		   'Detail' as MView, 
		   CategoryID as ReferenceID   
	 FROM  sunil_linensanddown_old.zsk_category c LEFT JOIN sunil_linensanddown_old.zsk_seo s on (s.ReferenceID=c.CategoryID AND s.RefrenceType='category') 
			WHERE 1
);

INSERT INTO sunil_linensanddown.zsk_seo_images
(
	SELECT Image AS ImageID,
		   CategoryName as AltText,
		   LOWER(REPLACE(REPLACE(REPLACE(URLName,'&',''),' ','-'),'--','-')) as URLName,
		   'catalog_category' as SourcePath,
		   'category' as DirPath
		   FROM  sunil_linensanddown_old.zsk_category c LEFT JOIN sunil_linensanddown_old.zsk_seo s on (s.ReferenceID=c.CategoryID AND s.RefrenceType='category') 
		   WHERE Image != '' 
		   GROUP BY Image
);


--- Categories  End

INSERT INTO sunil_linensanddown.zsk_plugin_faqs
(
	SELECT FaqID,FaqTitle as Question,LongDescription as Answer,Active,Position,CreatedDate  FROM sunil_linensanddown_old.zsk_other_faqs  WHERE 1
);




=============================================================================================================================
--- CMS Pages 
SELECT group_concat(column_name order by ordinal_position) from information_schema.columns where 
table_schema = 'sunil_linensanddown' and table_name = 'zsk_cms_pages';

INSERT INTO sunil_linensanddown.zsk_cms_pages
(
	SELECT 
	NULL as PageID,
	'0' as ParentID,
	title as PageName,
	title as LinkTitle,
	pageheading as LeftTitle1,
	description as LeftDescription1,
	description2 as LeftDescription2,
	'' as UpperBanner1,
	'' as Template,
	'0' as PluginID,
	'1' as ModuleKey,
	feature as Active,
	position as Position,
	NOW() as CreatedDate
	FROM  sunil_linensanddown_old.weboption WHERE weboption = 'webpage' AND optionid > 1
);

INSERT INTO sunil_linensanddown.zsk_seo
(
	SELECT NULL AS URLID,
		   LOWER(CONCAT(REPLACE(REPLACE(REPLACE(title,'&',''),' ','-'),'--','-'),'-cms-',optionid)) as URLName,
		   metatitle as MetaTitle,
		   metakeywords as MetaKeyword,
		   metadesc as MetaDescription,
		   NULL as RedirectEnabled,
		   NULL as RedirectURL,
		   'cms_pages' as MCode,
		   'Detail' as MView, 
		   optionid as ReferenceID   FROM sunil_linensanddown_old.weboption WHERE weboption = 'webpage' AND optionid > 1
);

UPDATE sunil_linensanddown.zsk_seo SET URLName = LOWER (URLName) WHERE MCode = 'cms_pages';

--- CMS Pages END

--- download_file START
INSERT INTO sunil_linensanddown.zsk_document_category
(
	SELECT CategoryID,CategoryName,Active,Position,CreatedDate FROM sunil_linensanddown_old.zsk_other_categories  WHERE CategoryType='download_file'
);

INSERT INTO sunil_linensanddown.zsk_documents
(
	SELECT FileID as DocumentID,
		   ReferenceID as CategoryID,
		   FileName as DocumentName,
		   FileName as DocumentTitle,
		   '' as DocumentType,
		   '' as UserID,
		   '' as Description,
		   Image as Image,
		   Upload as Upload,
		   Position,
		   Active,
		   CreatedDate
		   FROM sunil_linensanddown_old.zsk_other_files ORDER BY `zsk_other_files`.`FileID` ASC 
);
--- CMS Pages END

https://www.crystalfaucets.com/six-sided-picknmix-card-display-stand-p-2736.html

Product Import
http://php82.development.com/sunil/custom_cms/thetrophysite/data_import/scripts/product_import.php

User Import
http://php82.development.com/sunil/custom_cms/thetrophysite/data_import/scripts/user_import.php


Order Import
http://php82.development.com/sunil/custom_cms/thetrophysite/data_import/scripts/order_import.php


Below is not process yet
=============================================================================================================================


--- Manufacturers 
No manufacturers


Product import
http://php82.development.com/sunil/custom_cms/thetrophysite//data_import/scripts/product_import.php


UPDATE sunil_linensanddown.zsk_product SET TaxClass=1 WHERE 1
UPDATE sunil_linensanddown.zsk_product SET PrintingOptions=1 WHERE ProductID IN (SELECT ProductID FROM sunil_linensanddown_old.product  WHERE FreeMedal=1)


INSERT INTO sunil_linensanddown.zsk_users_newsletter
(
	SELECT NULL AS UserNewsletterID,UserID,DisplayName,Email,CreatedDate   FROM sunil_linensanddown_old.users_newsletter WHERE 1
);	

http://php82.development.com/sunil/custom_cms/thetrophysite//data_import/scripts/user_import.php

http://php82.development.com/sunil/custom_cms/thetrophysite//data_import/scripts/order_import.php

====================================================================================
====================================================================================
Below is not process yet



--- Product Start  

INSERT INTO sunil_linensanddown.zsk_product
(
	SELECT ProductID,'0' as MasterID,'Simple' as ProductType,'' as ProductAttribute,
			ProductName,ProductLine,MNID,SmallDescription,LargeDescription,'' as YoutubeVideo,'' as YouTubeVideo2,'0' as WithVat,
			Stock,'' as StockMessage,'0' as  StockTotal,'0' as StockStatus,'0' as  EndStock,'' as StockType, 
		   '0' as MinStockLevel,ModelNo,Image,Image as Thumbnail,ProductName as ImageTitle,Weight,'0' as ProductPoints,Active,Position,'' as Template,
		   '0' as TaxClass,'0' as VirtualProduct,'0' as PurchaseOnline,'' as PurchaseURL,'' as GoogleBrand,'' as GoogleGtin,'' as GoogleMPN,'' as QuickBooksCode,'' as Banner1,'' as UpperBanner1,'0' as FreeShippingStatus,'0' as GiftVoucherStatus,'0' as NotForSale,'0' as SignedIn,'0' as FeedID,'' as UploadType,now() as CreatedDate FROM sunil_linensanddown_old.product 
);

INSERT INTO sunil_linensanddown.zsk_product
(
	SELECT ProductID,'0' as MasterID,'Simple' as ProductType,'' as ProductAttribute,ProductName,ProductLine,MNID,SmallDescription,LargeDescription,'' as YoutubeVideo,'' as YouTubeVideo2,'0' as WithVat,Stock,'' as StockMessage,'0' as  StockTotal,'0' as StockStatus,'0' as  EndStock,'' as StockType, 
		   '0' as MinStockLevel,ModelNo,Image,Image as Thumbnail,ProductName as ImageTitle,Weight,'0' as ProductPoints,Active,Position,'' as Template,
		   '0' as TaxClass,'0' as VirtualProduct,'0' as PurchaseOnline,'' as PurchaseURL,'' as GoogleBrand,'' as GoogleGtin,'' as GoogleMPN,'' as QuickBooksCode,'' as Banner1,'' as UpperBanner1,'0' as FreeShippingStatus,'0' as GiftVoucherStatus,'0' as NotForSale,'0' as SignedIn,'0' as FeedID,'' as UploadType,now() as CreatedDate FROM sunil_linensanddown_old.product 
);

SELECT * FROM sunil_linensanddown_old.productcategory WHERE `ProductID` NOT IN (select ProductID from sunil_linensanddown_old.product);
UPDATE sunil_linensanddown.zsk_product SET ShippingProductID=1 WHERE ProductType='Simple' AND `ProductID` IN (select ProductID from sunil_linensanddown_old.product WHERE GroupID=1);
UPDATE sunil_linensanddown.zsk_product SET ShippingProductID=2 WHERE ProductType='Simple' AND `ProductID` IN (select ProductID from sunil_linensanddown_old.product WHERE GroupID=2);
UPDATE sunil_linensanddown.zsk_product SET ShippingProductID=4 WHERE ProductType='Simple' AND `ProductID` IN (select ProductID from sunil_linensanddown_old.product WHERE GroupID=4);
UPDATE sunil_linensanddown.zsk_product SET ShippingProductID=5 WHERE ProductType='Simple' AND `ProductID` IN (select ProductID from sunil_linensanddown_old.product WHERE GroupID=5);




SET foreign_key_checks = 0;
INSERT INTO sunil_linensanddown.zsk_product_relation
(
	SELECT id,ProductID,CategoryID as RelationID,'catalog_category' as RelationType,'0' as Custom,'0' as SortOrder  FROM sunil_linensanddown_old.productcategory 
);

INSERT INTO sunil_linensanddown.zsk_product_prices
(
	SELECT NULL as ProductPriceID,ProductID,'1' as UserTypeID,'Unit' as PriceType,'0' as QtyMin,'99999' as QtyMax,Price,SalePrice,SaleActive,NULL as SaleStartDate,NULL as SaleEndDate  FROM sunil_linensanddown_old.product 
);


INSERT INTO sunil_linensanddown.zsk_seo
(
	SELECT NULL AS URLID,URLName,MetaTitle,MetaKeyword,MetaDescription,'0' as RedirectEnabled,'' as RedirectURL,'catalog_product' as MCode,'Detail' as MView,ProductID as ReferenceID   FROM sunil_linensanddown_old.product 
);

UPDATE sunil_linensanddown.zsk_seo SET URLName =CONCAT('product-',URLName)  WHERE MCode='catalog_product';

INSERT INTO sunil_linensanddown.zsk_attribute_value 
(
	SELECT NULL as AttributeValueID,'1' as AttributeID,Attribute1 as AttributeValue, '1' as Active, '1' as Position, now() as CreatedDate FROM sunil_linensanddown_old.product_options WHERE Attribute1 != '' GROUP BY Attribute1
);

INSERT INTO sunil_linensanddown.zsk_attribute_value 
(
	SELECT NULL as AttributeValueID,'2' as AttributeID,Attribute2 as AttributeValue, '1' as Active, '1' as Position, now() as CreatedDate FROM sunil_linensanddown_old.product_options WHERE Attribute2 != '' GROUP BY Attribute2
);


INSERT INTO sunil_linensanddown.zsk_plugin_testimonials
(
	SELECT t.TestimonialID,Name as ClientName,UserEmail as ClientEmail,'' as ClientPhone,'' as ClientState,'' as ClientCountry,LongDescription as ClientMessage,'0' as Rating,Active as Status,Position,'' as UnpublishCode,t.CreatedDate 
	FROM sunil_linensanddown_old.other_testmonial t LEFT JOIN sunil_linensanddown_old.user_testmonial ut on t.TestimonialID = ut.TestimonialID 
	WHERE 1 GROUP BY t.TestimonialID ORDER BY t.TestimonialID
)

INSERT INTO sunil_linensanddown.zsk_shipping_product_band_prices
(
	SELECT NULL as ID, BandID as ShippingBandID, RangeMin, RangeMax, NormalPrice as Price, '0' as ExtraShipping, '0' as Active 
 	FROM sunil_linensanddown_old.shippingranges WHERE 1 ORDER BY ShippingRangeID
)

http://php82.development.com/sunil/custom_cms/thetrophysite/data_import/scripts/product_price_updates.php
http://php82.development.com/sunil/custom_cms/thetrophysite/data_import/scripts/user_import.php

TRUNCATE `zsk_order_change_status`;
TRUNCATE `zsk_order_currencies`;
TRUNCATE `zsk_order_details`;
TRUNCATE `zsk_order_log`;
TRUNCATE `zsk_order_message`;
TRUNCATE `zsk_order_murphy`;
TRUNCATE `zsk_orders`;
http://php82.development.com/sunil/custom_cms/thetrophysite/data_import/scripts/order_import.php




NOT IN USE 
INSERT INTO sunil_linensanddown.zsk_product_images
(
	SELECT ImageID,ProductID,Image,'' as ImageName,'' as ImageType,'0' as DefaultImage,Active,Position  FROM sunil_linensanddown_old.product_images 
);

NOT IN USE 
INSERT INTO sunil_linensanddown.zsk_product_additions
(
	SELECT ProductAdditionID,ProductID,AttributeName,AttributeValue,'' as ModelNo,'0' as NormalPrice,Price,PriceSet,CreatedDate   FROM sunil_linensanddown_old.product_additions 
);

NOT IN USE 
SELECT * FROM sunil_linensanddown_old.product_info WHERE `ProductID` NOT IN (select ProductID from sunil_linensanddown_old.product);

NOT IN USE 
DELETE FROM sunil_linensanddown_old.product_info WHERE `ProductID` NOT IN (select ProductID from sunil_linensanddown_old.product)

NOT IN USE 
INSERT INTO sunil_linensanddown.zsk_product_info
(
	SELECT *  FROM sunil_linensanddown_old.product_info 
);

NOT IN USE 
SELECT * FROM sunil_linensanddown_old.product_questions WHERE `ProductID` NOT IN (select ProductID from sunil_linensanddown_old.product);

NOT IN USE 
DELETE FROM sunil_linensanddown_old.product_questions WHERE `ProductID` NOT IN (select ProductID from sunil_linensanddown_old.product);
NOT IN USE 
INSERT INTO sunil_linensanddown.zsk_product_questions
(
	SELECT *  FROM sunil_linensanddown_old.product_questions 
);



NOT IN USE 
SELECT * FROM sunil_linensanddown_old.product_reg_code WHERE `ProductID` NOT IN (select ProductID from sunil_linensanddown_old.product);
ALTER TABLE `zsk_product_reg_code` CHANGE `ProductID` `ProductID` BIGINT NULL DEFAULT NULL;
ALTER TABLE `zsk_product_reg_code` ADD  FOREIGN KEY (`ProductID`) REFERENCES `zsk_product`(`ProductID`) ON DELETE CASCADE ON UPDATE CASCADE;

-- Copy table zsk_product_download

NOT IN USE 
INSERT INTO sunil_linensanddown.zsk_product_reviews
(
	SELECT *  FROM sunil_linensanddown_old.product_reviews 
);


-- PRODUCT Registration Code START  
NOT IN USE 
INSERT INTO sunil_linensanddown.zsk_product_codes
(
	SELECT NULL AS CodeID, ProductID,RegistrationCode as ProductCode,'' as CodeType,Active,CreatedDate FROM sunil_linensanddown_old.product WHERE RegistrationCode != '' GROUP BY RegistrationCode
);

-- PRODUCT Registration Code END


--- Product END  


NOT IN USE 
--  Related product inserted in the new database
data_import/scripts/product_related.php 



---  Related AttributeType 
UPDATE `zsk_product_additions` SET AttributeType = 'select';


-- USER START 
-- Copy table zsk_users
SELECT group_concat(column_name order by ordinal_position) from information_schema.columns where table_schema = 'sunil_linensanddown' and table_name = 'zsk_users';

INSERT INTO sunil_linensanddown.zsk_users
(
	SELECT UserID,UserName,Email,Password,FirstName,LastName,DOB,'' as Gender,'' as Goal,Address1,Address2,City,State,'' as Area,Country,ZipCode,Phone,Active,ActivationCode,ForgetCode,ActiveOnce,WholeSaler,VIPStatus,GvAmount,'' as AccountCode,PrevLastLogin,LastLogin,IPAddress,CreatedDate FROM sunil_linensanddown_old.users 
);

-- Assign Default UserType
INSERT INTO sunil_linensanddown.zsk_user_type_relation
(
	SELECT NULL AS RelationID,'1' as UserTypeID,UserID,'0' as Discount,CreatedDate FROM sunil_linensanddown_old.users 
);

-- Assign WholeSaler UserType
INSERT INTO sunil_linensanddown.zsk_user_type_relation
(
	SELECT NULL AS RelationID,'2' as UserTypeID,UserID,'0' as Discount,CreatedDate FROM sunil_linensanddown_old.users WHERE WholeSaler = '1'
);

-- Assign VIPStatus UserType
INSERT INTO sunil_linensanddown.zsk_user_type_relation
(
	SELECT NULL AS RelationID,'3' as UserTypeID,UserID,'0' as Discount,CreatedDate FROM sunil_linensanddown_old.users WHERE VIPStatus = '1'
);


-- Copy table zsk_users_address
SELECT group_concat(column_name order by ordinal_position) from information_schema.columns where table_schema = 'sunil_linensanddown' and table_name = 'zsk_users_address';

INSERT INTO sunil_linensanddown.zsk_users_address
(
	SELECT AddressID,UserID,FirstName,LastName,Address1,Address2,City,State,'' as Area,Country,ZipCode,Phone,'0' as DefaultAddress,AddressType,CreatedDate FROM sunil_linensanddown_old.users_address 
);


-- Copy table zsk_users_emails
SELECT group_concat(column_name order by ordinal_position) from information_schema.columns where table_schema = 'sunil_linensanddown' and table_name = 'zsk_users_emails';

INSERT INTO sunil_linensanddown.zsk_users_emails
(
	SELECT UserEmailID,Email,UserID,CreatedDate FROM sunil_linensanddown_old.users_emails 
);

-- Copy table zsk_users_newsletter
SELECT group_concat(column_name order by ordinal_position) from information_schema.columns where table_schema = 'sunil_linensanddown' and table_name = 'zsk_users_newsletter';

INSERT INTO sunil_linensanddown.zsk_users_newsletter
(
	SELECT UserID,Email as DisplayName,Email,CreatedDate FROM sunil_linensanddown_old.users_newsletter 
);


-- Copy table zsk_users_payment
SELECT group_concat(column_name order by ordinal_position) from information_schema.columns where table_schema = 'sunil_linensanddown' and table_name = 'zsk_users_payment';

INSERT INTO sunil_linensanddown.zsk_users_payment
(
	SELECT PaymentID,UserID,ReferenceID,TxnID,FromDate,ToDate,PaymentData,CreatedDate FROM sunil_linensanddown_old.users_payment 
);

-- Copy table zsk_users_point
SELECT group_concat(column_name order by ordinal_position) from information_schema.columns where table_schema = 'sunil_linensanddown' and table_name = 'zsk_users_point';

DELETE FROM sunil_linensanddown_old.users_point WHERE `UserID` NOT IN (select UserID from sunil_linensanddown_old.users);
INSERT INTO sunil_linensanddown.zsk_users_point
(
	SELECT PointID,UserID,OrderID,CouponID,Points,OrderStatus,PointStatus,CreatedDate FROM sunil_linensanddown_old.users_point 
);

-- Copy table zsk_users_watchlist
SELECT group_concat(column_name order by ordinal_position) from information_schema.columns where table_schema = 'sunil_linensanddown' and table_name = 'zsk_users_watchlist';

INSERT INTO sunil_linensanddown.zsk_users_watchlist
(
	SELECT WatchListID,ProductID,ProductOptionID,UserID,CreatedDate FROM sunil_linensanddown_old.users_watchlist 
);


-- Copy table zsk_users_wcategory
SELECT group_concat(column_name order by ordinal_position) from information_schema.columns where table_schema = 'sunil_linensanddown' and table_name = 'zsk_users_wcategory';

INSERT INTO sunil_linensanddown.zsk_users_wcategory
(
	SELECT WCategoryID,CategoryName,UserID,CreatedDate FROM sunil_linensanddown_old.users_wcategory 
);


-- Copy table zsk_users_wishlist
SELECT group_concat(column_name order by ordinal_position) from information_schema.columns where table_schema = 'sunil_linensanddown' and table_name = 'zsk_users_wishlist';

DELETE FROM sunil_linensanddown_old.users_wishlist WHERE `UserID` NOT IN (select UserID from sunil_linensanddown_old.users);
DELETE FROM sunil_linensanddown_old.users_wishlist WHERE `WCategoryID` NOT IN (select WCategoryID from sunil_linensanddown_old.users_wcategory);
INSERT INTO sunil_linensanddown.zsk_users_wishlist
(
	SELECT WishListID,WCategoryID,ProductID,UserID,WListType,CreatedDate FROM sunil_linensanddown_old.users_wishlist 
);


-- Delete empty record
DELETE FROM `zsk_users` WHERE `zsk_users`.`UserID` = '_d72343787975d1f70ad4507734b428ad';
DELETE FROM `zsk_users` WHERE `zsk_users`.`UserID` = '_96425a2023335adca32830e4d3873520';
DELETE FROM `zsk_users` WHERE `zsk_users`.`UserID` = '_079079ccbde77da7104ab39889190894';
DELETE FROM `zsk_users` WHERE `zsk_users`.`UserID` = '1_dc14306d3bca1b55cb8cc9f288f53bd7';
DELETE FROM `zsk_users` WHERE `zsk_users`.`UserID` = '1_edc546a702a7fcff230f4a396b67306c';
DELETE FROM `zsk_users` WHERE `zsk_users`.`UserID` = '1_86e38143f82b92e9e914bbc1889c5ff0';
DELETE FROM `zsk_users` WHERE `zsk_users`.`UserID` = '1_7a4071390bc3d470f6ed386e3983953c';

-- USER END  








-- Copy table zsk_coupons
SELECT group_concat(column_name order by ordinal_position) from information_schema.columns where table_schema = 'sunil_linensanddown' and table_name = 'zsk_coupons';
INSERT INTO sunil_linensanddown.zsk_coupons
(
	SELECT CouponID,CouponName,CouponType,CouponCode,CouponValue,Active,ProductSpecific,ProductIDs,'0' as CouponLimit,'0' as CouponUsed,'0' as MinTotal,GvEnabled,GvRedeem,RedeemDate,PurchasedOrderID,OrderID,StartDate,EndDate,Message,CreatedDate FROM sunil_linensanddown_old.coupons  WHERE 1 ORDER BY  CouponID ASC
);

UPDATE `zsk_coupons`  SET MultipleEnabled = GvEnabled;

-- copy zsk_product_bundles from zsk_bundle
SELECT * FROM sunil_linensanddown.zsk_product_bundles WHERE `ProductID` NOT IN (select ProductID from sunil_linensanddown.zsk_product);
DELETE FROM sunil_linensanddown.zsk_product_bundles WHERE `ProductID` NOT IN (select ProductID from sunil_linensanddown.zsk_product)


/* Increase ID */
ProductID = 100001;
OrderID   = 210001;
OrderDetailID = 1000001;
CouponID = 10001;

SELECT * FROM `zsk_product` WHERE ProductID <100001 ORDER BY ProductID DESC;
DELETE FROM `zsk_product` WHERE ProductID <100001;

Sequence of Import
1. product_import.php
data_import/scripts/product_import.php
http://132.148.9.23/data_import/scripts/product_import.php
http://gurbir7.dev.wcukdev.co.uk/alakazam/data_import/scripts/product_import.php

2. user_import.php
data_import/scripts/user_import.php
http://132.148.9.23/data_import/scripts/user_import.php
http://gurbir7.dev.wcukdev.co.uk/alakazam/data_import/scripts/user_import.php


3. client_import.php
data_import/scripts/client_import.php
http://132.148.9.23/data_import/scripts/client_import.php
http://gurbir7.dev.wcukdev.co.uk/alakazam/data_import/scripts/client_import.php

4. order_import.php
data_import/scripts/order_import.php
http://132.148.9.23/data_import/scripts/order_import.php
http://gurbir7.dev.wcukdev.co.uk/alakazam/data_import/scripts/order_import.php

5. coupon_import.php
data_import/scripts/coupon_import.php
http://132.148.9.23/data_import/scripts/coupon_import.php
http://gurbir7.dev.wcukdev.co.uk/alakazam/data_import/scripts/coupon_import.php

6. product_coupon_import.php
data_import/scripts/product_coupon_import.php
http://132.148.9.23/data_import/scripts/product_coupon_import.php
http://gurbir7.dev.wcukdev.co.uk/alakazam/data_import/scripts/product_coupon_import.php


7. product_description_format.php (if needed optional)
data_import/scripts/product_description_format.php
http://132.148.9.23/data_import/scripts/product_description_format.php



Last Queue: 
http://132.148.9.23/data_import/scripts/order_import.php?index=37000
 
Special filter order 
https://alakazam.co.uk/data_import/scripts/order_import_filter.php?Email=c-foster@tiscali.co.uk

SELECT `o`.`OrderID` AS `OrderID`, `o`.`CreatedDate` AS `OrderCreatedDate`, 
`o`.`OrderNo` AS `OrderNo`, `o`.`DownloadID` AS `DownloadID`, `od`.`OrderDetailID` AS `OrderDetailID`, 
`od`.`ReferenceID` AS `ReferenceID`, `p`.* FROM `zsk_orders` AS `o` INNER JOIN 
`zsk_order_details` AS `od` ON (od.OrderID=o.OrderID) INNER JOIN `zsk_product` AS `p` ON (p.ProductID=od.ReferenceID) 
WHERE 
`o`.`PaymentStatus` = 'Paid' AND `o`.`DownloadID` != '' AND 
`od`.`ItemType` = 'Product' 
AND `o`.`CreatedDate` < '2015-01-01'
GROUP BY `o`.`OrderID` 
ORDER BY `o`.`CreatedDate` ASC