Athetral

Athetral 13 years ago

I have 30000 products and tried to upload, but its not letting me upload more than in one shot. This extension is working but not letting me upload more than 300 products. I have 30000 products with 370 categories. When i import the excel sheet, it doesn't give me any error or any uploaded message. Please help me to figure it out the root cause.

Jonesy200

Jonesy200 13 years ago

Would you check a file for me and see why it is not working please. I have downloaded the present site and filled with all the information I need to but must have missed something. When I first tried it was rejected due to size so spoke to my web host and got this fixed now it is allowed to upload but it killed the site, they won't help with this.

If you could send me an email to kandltjones@bigpond.com if you are happy to look over my upload file it would be very much appreciated as it will save me so much work

I know I have it installed your extension properly as it is exporting perfectly and have used on another website it is a great asset. I am off to 12 hour shift so if you answer promptly sorry for my so reply in advance

Regards

gagan_singh85

gagan_singh85 13 years ago

i got the same error..:(

Jonesy200

Jonesy200 13 years ago

Also my file size is only 1.6mb no where near the maximum memory size????

Jonesy200

Jonesy200 13 years ago

I uploaded my spreadsheet to my new site and got this error message, please help me fix

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 71 bytes) in /home/importso/public_html/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 130

eddiechun1027

eddiechun1027 13 years ago

Fatal Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 46318 bytes) in /home/XXXXXXXX/public_html/admin/model/tool/export.php on line 488

How can I configure allowed memory size?

pstruh

pstruh 13 years ago

@Anthony1632: can you please share your developer info. I need exactly what you have. I am willing to donate some extra cost. Please contact me on email salemko99@gmail.com

skullnbones

skullnbones 13 years ago

@Anthony1632: Hello, Can you give me your developers contact info I would like to do this as well. sales [a] skullnbonesclothing.com thank you

vijay.priyani

vijay.priyani 13 years ago

Notice: Error: MySQL server has gone away
Error No: 2006
DESCRIBE `option_value`; in /home/______/public_html/system/database/mysql.php on line 49

Showing this error.....can you help....

pstruh

pstruh 13 years ago

any new release with increment import which solve the memory issue problem ?

Beamer

Beamer 13 years ago

Extensions works fine, nice work!

Just one little question, in my export sheet there is no column for 'Product naam (SEO)'
Could you please inform me what file i need to change / what i need to add so this is also in the
export / import sheet.

Thanks in advance!

Kind Regards,

Maikel

meetgerry

meetgerry 13 years ago

AS categories, p.sku, p.upc, p.location, p.quantity, p.model, m.name AS manufacturer, p.image AS image_name, p.shipping, p.price, p.points, p.date_added, p.date_modified, p.date_available, p.weight, wc.unit, p.length, p.width, p.height, p.status, p.tax_class_id, p.viewed, p.sort_order, pd.language_id, ua.keyword, pd.description, pd.meta_description, pd.meta_keyword, p.stock_status_id, mc.unit AS length_unit, p.subtract, p.minimum, GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR "," ) AS related, GROUP_CONCAT( DISTINCT pt.tag SEPARATOR "," ) AS tags FROM `gb_product` p LEFT JOIN `gb_product_description` pd ON p.product_id=pd.product_id AND pd.language_id=1 LEFT JOIN `gb_product_to_category` pc ON

meetgerry

meetgerry 13 years ago

Hello,

I am using the latest version "Version 1.5.5.1"

I get the following error. What could be the problem?

Warning: set_time_limit() [function.set-time-limit]: Cannot set time limit in safe mode in /mounted-storage/home127/sub030/sc75260-VNGF/gadgetbadgers.com/admin/controller/tool/export.php on line 76Notice: Error: Unknown column 'pt.tag' in 'field list'

Error No: 1054

SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," )

gpenakaiser

gpenakaiser 13 years ago

@gpenakaiser: please tell su something abot our questions

marieneige

marieneige 13 years ago

I would be interested too in gpenakaiser request. I find this extension very great though I am sad the filters did not export on the file and it is so long to add them one by one!

gpenakaiser

gpenakaiser 13 years ago

Hi,

I have a couple of questions. First my store has 2 languages. To load data on each language, I should have one Excel per language? The second one is because of I added a new field on 3 diferent tables (manufacturer, category and product table). It's easy to modify code to import and export new field too? What I should do it? I you can do it by me, I can pay money you.

Regards.

robscratch

robscratch 13 years ago

I've installed on 1.5.5 and I'm getting this error, can you help?

Fatal error: Call to undefined method Loader::language() in /var/sites/r/reliablereptile.co.uk/public_html/admin/controller/tool/export.php on line 6

goko_u

goko_u 13 years ago

Hi Guys,

I have about 840 product in my store that is opencart 1.5.1.3. Export import tool was working properly five months ago. But, it is not working now. When I have started import process, it is doing something for a long time then view only a blank page. How can I do? Thank you for your comments.

sendil22

sendil22 13 years ago

Hi JNeuhoff,
When I export and open the excel, it doesn't show any column names. Without column names we can add more products to excel and import.

Kindly help us.
Thanks & Regards

Pulhao

Pulhao 13 years ago

@cartcreator: everything seens to be fine !
great module man ! congrats ,

, if i create a new line the product will be added ?
and then can i edit it in admin module ?

thanks in advance !