The Community forums are being phased out in favor of a new Slack group.
Add your email address below to get an invitation to join the community slack group

Slack Signup
Newsletter Optin
Help Desk

Custom csv import with local images

Labels

This Discussion is public

Notifications

Hi,

We have the need to create WP custom post by importing a zip that contain a csv file and an images folder.

ZIP
- my-products.csv
- images
-- image1.jpg
-- image2.jpg
-- image3.jpg
-- image4.jpg

The import zip csv is (can have more columns):
"date", "title", "price", "description", "image1", "image2", "image3"
"01-12-2017", "product1", "100", "Lorem ipsum","001-001.jpg", "001-002.jpg", ""
"01-12-2017", "product2", "200", "Dolores si amet","002-001.jpg", "002-002.jpg", "002-003.jpg"

New import zip csv is (can have more columns):
"date", "title", "price", "description","image1", "image2", "image3"
"02-01-2017", "product3", "500", "Consegur terni alep","001-001.jpg", "001-002.jpg", ""
"02-01-2017", "product4", "300", "Sed astrolab","002-001.jpg", "002-002.jpg", ""
"02-01-2017", "product5", "300", "Lorem ipsum","003-001.jpg", "003-002.jpg", "003-003.jpg"

That should create:

1. A listing view with date (each import has a new date field):
- 01-12-2017 (link to product list)
- 02-01-2018 (link to product list)
- ...

2. A product listing view per date
Ex for 01-12-2017:
- Product 1 + 001-001.jpg (link to product detail page with other datas from csv)
- Product 2 + 002-001.jpg (link to product detail page with other datas from csv)
- ...

Ex for 02-01-2018:
- Product 3 + 001-001.jpg (link to product detail page with other datas from csv)
- Product 4 + 002-001.jpg (link to product detail page with other datas from csv)
- Product 5 + 003-001.jpg (link to product detail page with other datas from csv)
- ...

The custom fields and views can be done easily with ACF or Formidable Pro plugins.

We need a developper to help create the import function capable to import the ZIP, extract content and upload images then maps images to corresponding product.

Please note that on each import images will have the same pattern name 00X-00Y.jpg where X in the index of product in the import and Y is 1 for image 1, 2 for image 2

On 25 février 2018 date you will see images. This example has been done easily with a csv with reference to image that are already online (http) says we did not have the need to upload the images on the import. Our issue is that images are not hosted, they are on local computer and we need to import them as a bulk import with the zip containing both csv and image folder.

Thanks

Discussion closed.