Downloaded CSV file with import can't see products

  • Posts: 7
  • Thank you received: 0
13 years 9 months ago #7129

I recently started working on my first site, and i am useing my mac and a localhost setup not live yet. I downloaded and formatted a example csv file so i got a understanding of it, and once i got all the errors repaired, it said it downloaded. When i went into my products to see my vast array of 27 products i created I am unable to see them. I went to products>root> and nothing was there. Do i have to enable something. I went to the help section and didnt see anything. Thank you for your help this is my first time using a forum.

WR
Daniel

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
13 years 9 months ago #7131

If you don't see your products it's probably because they aren't linked to your categories.

If you use the latest version of HikaShop, the products should be linked to the main product category if no category is specified in the CSV.

Did you specify a column categories in your CSV ?

Please Log in or Create an account to join the conversation.

  • Posts: 7
  • Thank you received: 0
13 years 9 months ago #7132

I have attached the file, it is very basic as i am completely learning from scratch how to do this. I do thank you for the quick response also.

File Attachment:

File Name: test2.csv
File Size:60 KB

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
13 years 9 months ago #7133

Since you don't have any categories column specified, hikashop should insert your products below the "product category" category, which is the default product category created by hikashop during the install. Do you still have that category ? Do you see your products under that category ?

Please Log in or Create an account to join the conversation.

  • Posts: 7
  • Thank you received: 0
13 years 9 months ago #7172

Explorer
Root
Product category

That is all that is shown i am in the product section on the left hand side is a what looks like a house and says "root" then below that is a folder that says "product category" when you click on it there is no action to it. It's as if its empty?

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
13 years 9 months ago #7174

Are you looking looking at the listing of categories or the listing of products ? Because it's normal that you don't get anything in the listing of categories.

Otherwise, could you provide an access to your website so that we can check your settings ?

Please Log in or Create an account to join the conversation.

  • Posts: 7
  • Thank you received: 0
13 years 9 months ago #7239

I am building from a local site, so i can try to upload it but i am definitely in products screen in joomla.


New Edit Delete Help Control panel
Products
SystemSystem
ConfigurationZonesPayment methodsShipping methodsTaxesCurrenciesDiscountsOrder statuses
ProductsProducts
Add a productProductsCategoriesCharacteristicsImport
CustomersCustomers
Customers
SalesSales
Sales
DisplayDisplay
ViewsContent menusContent modulesCustom fields
HelpHelp
DocumentationUpdate / AboutForum

* Products
* Categories
* Users
* Orders
* Configuration
* Discounts
* Help
* Update / About

Explorer
Root
Product category

Root/ Filter: Go Reset
# Name Code Price Quantity Order Save Order Published ID
Display #
No records found
HikaShop Starter 1.4.4, Joomla!™ Online Shop System

Joomla! is Free Software released under the GNU/GPL License.

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
13 years 9 months ago #7240

Indeed. I don't know what to tell you. It works on our end...

Did you try to reimport your products ? What message do you get ? Do you get the products after that in the products listing ?
Could you do a screenshot of the product listing?

Please Log in or Create an account to join the conversation.

  • Posts: 7
  • Thank you received: 0
13 years 9 months ago #7253

I have attached the cvs i am tring to upload, i just tried again with the same file and this is as it reads "27 products found : 0 new products imported, 0 invalid product code, 27 already existing products". Could it be a database area with phpadmin or mysgl?

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
13 years 9 months ago #7263

Could you delete the products already imported in the table hikashop_product and try with that CSV file ?

File Attachment:

File Name: test2-20110208.csv
File Size:60 KB

Attachments:
The following user(s) said Thank You: FidelGonzales

Please Log in or Create an account to join the conversation.

Time to create page: 0.070 seconds
Powered by Kunena Forum