Trying to Upload 340 products from a re-install

Hi

I am trying to re-upload 340 products.

I had to overhaul all of the products so I uninstalled Hikashop, deleted all of the SQL databases & reinstalled Hikashop.

When I re-upload the 340 products through CSV it says "340 products added" but then continues to display nothing?

My CSV file is simply 341 rows and 3 columns (340 products, 1 'product_name' column, 1 'images' column, 1 'categories' column

Why are the products not showing up?

I have definitely deleted all of the databases and made sure there was nothing else referencing them in CPANEL or SQL. Are they saved somewhere else?

cheers

Hi,

Sorry about the delay.

No new categories are added and I cannot see any products on the front or back end.
Attached screen of what it looks like after the sheet is added.

Products DO get added to the hikashop_product table in the database each time.

Debug does not show any errors (I have taken the actual products out of the text below to make it easier to read)

"
SELECT `data`
FROM `szm89_session`
WHERE `session_id` = '22d727b87856dec19e70edbc8edd3164'
SELECT extension_id AS id, element AS "option", params, enabled
FROM szm89_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT folder AS type, element AS name, params
FROM szm89_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,2,3)
ORDER BY ordering
SELECT template, s.params
FROM szm89_template_styles as s
LEFT JOIN szm89_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
WHERE s.client_id = 1
AND home = 1
ORDER BY home
SELECT extension_id AS id, element AS "option", params, enabled
FROM szm89_extensions
WHERE `type` = 'component'
AND `element` = 'com_hikashop'
SELECT *
FROM szm89_hikashop_config
SELECT *
FROM szm89_hikashop_field as a
WHERE a.`field_published` = 1
AND a.field_table='product'
ORDER BY a.`field_ordering` ASC
SHOW FULL COLUMNS
FROM `szm89_hikashop_product`
SELECT *
FROM szm89_hikashop_characteristic
ORDER BY characteristic_parent_id ASC
SELECT category_id
FROM szm89_hikashop_category
WHERE category_type='root'
LIMIT 1
SELECT category_id
FROM szm89_hikashop_category
WHERE category_parent_id=1
AND category_type='product'
LIMIT 1
SELECT category_id
FROM szm89_hikashop_category
WHERE category_parent_id=1
AND category_type='manufacturer'
LIMIT 1
SHOW FULL COLUMNS
FROM `szm89_hikashop_product`
SELECT lang_id as id, lang_code as code, image as shortcode, published as active
FROM szm89_languages
WHERE published=1

SELECT *
FROM szm89_hikashop_product
WHERE product_code IN ('A_New_Day','Adornment','All_My_Heart_I',.......

REPLACE INTO szm89_hikashop_product (`product_weight`, `product_description`, `product_meta_description`, `product_tax_id`, `product_vendor_id`, `product_manufacturer_id`, `product_url`, `product_keywords`, `product_weight_unit`, `product_dimension_unit`, `product_width`, `product_length`, `product_height`, `product_max_per_order`, `product_name`, `product_published`, `product_code`, `product_created`, `product_modified`, `product_sale_start`, `product_sale_end`, `product_type`, `product_quantity`, `product_id`, `product_parent_id`, `product_hit`, `product_delay_id`, `product_access`, `product_group_after_purchase`, `product_min_per_order`, `product_contact`, `product_last_seen_date`, `product_sales`, `product_waitlist`, `product_layout`, `product_average_score`, `product_total_vote`)
VALUES ('0.000','','','0','0','0','','','kg','m','0.000','0.000','0.000','0','A New Day','1','A_New_Day','1339396550','1339396550','0','0','main','0','1','0','0','0','all','','0','0','0','0','0','','0','0'),('0.000','','','0','0','0','','','kg','m','0.000','0.000','0.000','0','Adornment','1','Adornment','1339396550','1339396550','0','0','main','0','2','0','0','0','all','','0','0','0','0','0','','0','0'),('0.000','','','0','0','0','','','kg','m','0.000','0.000','0.000','0','.......
SELECT product_code, product_id
FROM szm89_hikashop_product
WHERE product_code IN ('A_New_Day',........)
DELETE
FROM szm89_hikashop_file
WHERE file_ref_id IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50)
AND file_type='product'
INSERT IGNORE INTO szm89_hikashop_file (`file_name`,`file_description`,`file_path`,`file_type`,`file_ref_id`)
VALUES ('A New Day','','A New Day.jpg','product',1),('Adornment','','Adornment.jpg','product',2),'.........)

"

Ah. Perfect.

Thank you very much it works perfectly now.