Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: Uploaded (csv import) products not showing  (Read 8150 times)

Offline theodan

  • Newbie
  • *
  • Posts: 24
  • Karma: +1/-0
    • View Profile
Uploaded (csv import) products not showing
« on: August 26, 2015, 11:40:54 PM »
new install of version 123 does not show products, although when Exported all products do show. Cached cleared but products still not shown.
« Last Edit: August 28, 2015, 09:17:01 AM by Basara »

Offline webdevmerc

  • Full Member
  • ***
  • Posts: 172
  • Karma: +32/-1
    • View Profile
Re: Uploaded products not showing
« Reply #1 on: August 27, 2015, 09:22:35 AM »
Status and quantity available of items?  Screenshot?

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5807
  • Karma: +274/-2
    • View Profile
Re: Uploaded products not showing
« Reply #2 on: August 27, 2015, 09:50:18 AM »
Make sure you assign product to default store

Offline theodan

  • Newbie
  • *
  • Posts: 24
  • Karma: +1/-0
    • View Profile
Re: Uploaded products not showing
« Reply #3 on: August 27, 2015, 10:21:27 PM »
The screenshot is quite large with over 200 rows. The screenshot shows the first 25 rows. Just another note there were no error messages.

Thanks
Theodan

Offline webdevmerc

  • Full Member
  • ***
  • Posts: 172
  • Karma: +32/-1
    • View Profile
Re: Uploaded products not showing
« Reply #4 on: August 27, 2015, 11:17:21 PM »
I was actually referring to the screenshot of what a product listing looks like within Abantecart...

I don't know if the format is supposed to be different, but from the 1st column, should it be "insert" instead of "import"?

Also, should it be "option"?  I have "action" in my csv file.

TL:DR: my 1st column is:

action
insert
insert
insert
.
.
.
etc...

Also, if you have DB experience, the word "insert" is just what databases have used from as long as I can remember to add a new line...I don't know where you got the word import from, but my guess is that's not the correct syntax and causing the problems.  This is an example where more computer background is good overall (took many db classes years ago).

http://docs.abantecart.com/pages/tools/import.html

« Last Edit: November 01, 2016, 08:23:11 AM by Basara »

Offline theodan

  • Newbie
  • *
  • Posts: 24
  • Karma: +1/-0
    • View Profile
Re: Uploaded products not showing
« Reply #5 on: August 28, 2015, 02:48:12 AM »
Big goof. However, the products are in the cart and the download shows them. I actually had the file that was exported from the cart and added  option and import in Row A Column 1 before sending it. I made the corrections you suggested however and still no display. How do I clear these products so I can start over?

Thanks
Theodsn

Offline webdevmerc

  • Full Member
  • ***
  • Posts: 172
  • Karma: +32/-1
    • View Profile
Re: Uploaded products not showing
« Reply #6 on: August 28, 2015, 07:40:49 AM »
Are the products even showing up in the admin tool?  Under Catalog -> Products?  You can just delete them from there if you wanted to retry to import.

Also, one thing I've noticed is that html formatting or things you may copy from 1 website to another can break the import in Abantecart.  If you have very long descriptions, you may want to delete it all or try a few records first.



Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5807
  • Karma: +274/-2
    • View Profile

Offline theodan

  • Newbie
  • *
  • Posts: 24
  • Karma: +1/-0
    • View Profile
Re: Uploaded (csv import) products not showing
« Reply #8 on: August 29, 2015, 05:18:37 PM »
Hi, I have tried everything except the solution. My products are in the site because I can see them if I do a search on the entire site search bar. I can edit, add image save with confirmation that the changes were saved but still no display in products. I have cleared cache and switched the product.date_available with the products .date_added date and still no display in products. Can anyone help?

Offline theodan

  • Newbie
  • *
  • Posts: 24
  • Karma: +1/-0
    • View Profile
Re: Uploaded (csv import) products not showing
« Reply #9 on: August 30, 2015, 04:28:05 PM »
any help guys?

Offline webdevmerc

  • Full Member
  • ***
  • Posts: 172
  • Karma: +32/-1
    • View Profile
Re: Uploaded (csv import) products not showing
« Reply #10 on: August 30, 2015, 05:05:32 PM »
If I was in your shoes, I'd delete the current setup and just reload everything and load the demo data as well.  See if that stuff shows up correctly at all.  It's really hard to debug without looking at it directly to see what maybe causing the issue.

Having ran into numerous problems in my own setup, my general thoughts on all this is if only I am complaining about it, then it's probably just my environment and something is out of whack.  Could be simple, hard, just impossible to say and starting from scratch is my advice.

That said, I've rebuilt, reloaded this app 10-20 times easy...since I break stuff and don't know what I did (more often when I was learning a bit more)...

Sorry I don't have a better answer, but as the environment is new and you aren't live yet, it's good to know what's causing this NOW vs. when you are online already and this happens again.

At least get a baseline sorta working, then tweak what you have.

Offline theodan

  • Newbie
  • *
  • Posts: 24
  • Karma: +1/-0
    • View Profile
Re: Uploaded (csv import) products not showing
« Reply #11 on: August 30, 2015, 09:55:16 PM »
Good Idea, I'll reload and thanks.

Theodan

 

Powered by SMFPacks Social Login Mod