The 5th annual nopCommerce conference will take place in India on the 10th-11th of October. Please find more about this event here

Problems importing products file

Posted: January 06, 2017 at 12:02 AM Quote #181077
I am having problems importing my products file to my site.

I created the first 5 products individually on the site, then exported to Excel so I could use the correct formatting.
Inserted all my products and info, but now when I import it isnt populating into my products page.

I noticed when I go to the "Search engine friendly page names" there is a listing of a page for each of my products, but then if I click edit it takes me to the products tab, where there is no products.

Can anyone assist?
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: January 06, 2017 at 1:13 AM Quote #181080
If it showing on search engine friendly page then it should be good.

what happen when you click on Edit ?? if it not redirect to product edit page then are you getting any error message ??

can you check the System -> Log is there any error log added ??

if you are familier with database access may be you can directly check on Product table with query
Select * from Product order by id desc

so it will list out all product which is inserted recently.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Thanks & Regards
Vipul Dumaniya

Did you find this post useful? If so, please vote it up!

Email:[email protected]
Skype:vipul.dumaniya
Website: https://www.satyanamsoft.com/
Posted: January 06, 2017 at 1:43 AM Quote #181081
vipul.dumaniya wrote:
If it showing on search engine friendly page then it should be good.

what happen when you click on Edit ?? if it not redirect to product edit page then are you getting any error message ??

can you check the System -> Log is there any error log added ??

if you are familier with database access may be you can directly check on Product table with query
Select * from Product order by id desc

so it will list out all product which is inserted recently.




Thanks Vipul for your reply.
When I click edit it does redirect me to the product page, but it doesnt show the products I have imported.

When I tried this morning I received the following error message in "Log" - A disk error occurred during a write operation. (Exception from HRESULT: 0x8003001D (STG_E_WRITEFAULT))

Looking back to when I tried yesterday there is the following logged error - An error occurred while updating the entries. See the inner exception for details.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: January 06, 2017 at 3:31 AM Quote #181084
it seems like import is not done successfully as per the logs you mentions like error updating entity etc.

it require more troubleshooting exactly where it crashed or why not working may be its data issue that you setup on excel sheet.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Thanks & Regards
Vipul Dumaniya

Did you find this post useful? If so, please vote it up!

Email:[email protected]
Skype:vipul.dumaniya
Website: https://www.satyanamsoft.com/
Posted: January 06, 2017 at 3:58 AM Quote #181085
Ive exported and started on a blank sheet so many times.
It is still giving problems.

I tried to load a small sheet with only 10 new items, it says it has imported, yet they dont appear on the product listing.

Also, when I do any editing to the 4 items I entered manually from the Admin area, in the same Excel sheet the changes are visible once it completes importing.
Just not the new products
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: January 06, 2017 at 5:33 AM Quote #181097
Hi

please refer below links as your error log has same issue.

https://www.nopcommerce.com/boards/t/34387/a-disk-error-occurred-during-a-write-operation-while-importing-excel-with-product.aspx

https://www.nopcommerce.com/boards/t/35764/error-when-trying-excel-product-upload.aspx

Hope it helps
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Thanks & Regards
Vipul Dumaniya

Did you find this post useful? If so, please vote it up!

Email:[email protected]
Skype:vipul.dumaniya
Website: https://www.satyanamsoft.com/
Premium support services
  • Dedicated premium support services provided by core developers are intended for persons who run mission critical websites, work on projects with tight deadlines, or want to get dedicated support.
Professional services
  • Want to open a new store? Want to take your store to the next level? Need a custom extension? We can customize nopCommerce to fit your store perfectly. Request a quote to get started.
eCommerce CONFERENCE 2019
Learn more