Search found 7 matches

Page 1 of 1

Search found 7 matches

Would this SQL line work?

Hi there, I have imported some products with some incorrect stock status, would this SQL work? UPDATE `itmeup_product` SET stock_status_id = CASE WHEN quantity=0 THEN 5*stock_status_id ELSE stock_status_if END If Quantity is = then set Stock Status 5 = (Out of Stock) Currently its is showing as 6 (2...

Jump to post
  • Fri Jan 11, 2019 5:57 pm
  • Replies 1
  • Views 100
Extension Request - FTP Product Feed

Hi there,

Please could someone let me know if there is an extension I can use to do the following:
Log into Supplied FTP site
Download CSV / XML File (say 3 times per day)
Auto-Map the Supplier headers to the OC headers and import the data (Product, stock, images etc).

Thank you

Jump to post
  • Mon Aug 20, 2018 5:04 pm
  • Replies 7
  • Views 398
Extension Request - FTP Product Feed

Hi there,

Please could someone let me know if there is an extension I can use to do the following:
Log into Supplied FTP site
Download CSV / XML File (say 3 times per day)
Auto-Map the Supplier headers to the OC headers and import the data (Product, stock, images etc).

Thank you

Jump to post
  • Mon Aug 20, 2018 3:59 pm
  • Replies 1
  • Views 139
Re: Supplier FTP CSV/XML Feed - How to Import?

Thanks for the reply
I use this already but its not automated / does not take data from a live stock feed from my supplier.

Jump to post
  • Sat Aug 18, 2018 4:32 pm
  • Replies 3
  • Views 288
Supplier FTP CSV/XML Feed - How to Import?

Hi there, My Supplier has an FTP portal that contains a CSV and XML file. I would like to import this into my OpenCart Store to save me a tonne of time. What extension can I use to automate this process? I am happy to edit the CSV file... as I do not want to list all the items on my site but would p...

Jump to post
  • Fri Aug 17, 2018 11:21 pm
  • Replies 3
  • Views 288
Re: Transform CSV data into OpenCart Products

I forgot to add I have the Export/Import Module installed and the reason for my question is because I can see the current export uses the following headers just on the Product page, let alone the other tabs: product_id name(en-gb) categories sku upc ean jan isb mpn location quantity model manufactur...

Jump to post
  • Thu Sep 21, 2017 5:32 pm
  • Replies 1
  • Views 252
Transform CSV data into OpenCart Products

Hi there, My supplier has sent me a list of products in CSV format, using the following headers: Product Number Manufacturer Number Category Manufacturer Description Cost Stock Level Product Details Specification EAN Number Thumbnail Main Image Is it at all possible to use MySQL Workbench to import ...

Jump to post
  • Thu Sep 21, 2017 4:33 pm
  • Replies 1
  • Views 252

Page 1 of 1

Search found 7 matches