Jump to content

Data Import Problem Rate Topic   - - - - -

 

Posted 07 June 2012 - 07:44 PM #1

Hi,

I'm having in issue importing my products. I exported the inventory csv file with comma separated values, and copied all of my information to the exported csv file. When I go to upload it, it says loading for about a minute, and then it disappears, and no products or categories have been added. Does anyone know why this may be happening?

Thanks,

 
  • johnbol1
  • Senior Member
  • Members
  • Join Date: 23-Feb 10
  • 2,482 posts

Posted 07 June 2012 - 08:02 PM #2

could be a server memory problem, how many are you trying to import, try just a row or a few rows first to make sure it works.

John
www.hivis.co.uk the UK's online hivis safety marketplace

"Give me a man that tries and fails
than a man that never tries at all"

 

Posted 07 June 2012 - 08:24 PM #3

I tried one and it worked, but the product isn't showing up in the category. It shows up in the backend, and its listed under the category that its supposed to belong to. Getting back to the products, I have 33,000 products to import.

 
  • The Tool
  • Senior Member
  • Members
  • Join Date: 30-Mar 07
  • 2,382 posts

Posted 07 June 2012 - 09:16 PM #4

View Postgooddealz11, on 07 June 2012 - 08:24 PM, said:

Getting back to the products, I have 33,000 products to import.

More than likely a file size issue. You will need to configure the server to be able to upload a file of that size.
CS Cart Upgrade Repair - For sites that are slow and/or just not functioning correctly after upgrade(s). Files and/or Data base Structure. PM me.

 

Posted 07 June 2012 - 09:19 PM #5

It's a memory issue. I have increased it to 1GB and it still isn't working. Does anyone know how much memory that it will take to make this system work?

 

Posted 07 June 2012 - 09:52 PM #6

View PostThe Tool, on 07 June 2012 - 09:16 PM, said:

More than likely a file size issue. You will need to configure the server to be able to upload a file of that size.

That could also be an issue. I have my host looking into it. Its weird because I've never had a problem like this with any of the other cart systems that I have used in the past.

 

Posted 08 June 2012 - 06:04 AM #7

Still an issue. This is what my hosting company reported back to me.

We have looked into this further for you and even after increasing the server's memory, the error still occurs in the error_log for your site:
[08-Jun-2012 04:52:50 UTC] PHP Fatal error: Allowed memory size of 50331648 bytes exhausted (tried to allocate 16385 bytes) in /home/fragra9/public_html/core/fn.fs.php on line 861

 
  • The Tool
  • Senior Member
  • Members
  • Join Date: 30-Mar 07
  • 2,382 posts

Posted 08 June 2012 - 11:30 AM #8

That's because the cart is overriding the memory. In /config.local.php you need to edit the memory. Change 48 to your desired memory.

// Set maximum memory limit
@ini_set('memory_limit', '48M');

CS Cart Upgrade Repair - For sites that are slow and/or just not functioning correctly after upgrade(s). Files and/or Data base Structure. PM me.

 

Posted 08 June 2012 - 03:20 PM #9

Thanks Tool! I can't believe that I didn't even think to look at that yesterday, but either way it worked. Enjoy the rest of your day!

 
  • The Tool
  • Senior Member
  • Members
  • Join Date: 30-Mar 07
  • 2,382 posts

Posted 08 June 2012 - 04:54 PM #10

No problem. It always helps to have an error but the exact symptoms occur when file upload size is more than what the server is configured for.
CS Cart Upgrade Repair - For sites that are slow and/or just not functioning correctly after upgrade(s). Files and/or Data base Structure. PM me.