oc-mall-plugin icon indicating copy to clipboard operation
oc-mall-plugin copied to clipboard

Add Import/Export of Products and Orders

Open StanleyBonhomme opened this issue 6 years ago • 14 comments

Great plugin. A suggestion for improvement would be to add Import/Export of Products that way users can mass import/export products from a csv kind of like the Rainlab Blog plugin can import/export posts.

StanleyBonhomme avatar Jan 15 '19 14:01 StanleyBonhomme

Thank you for your input.

This is indeed a feature on our wishlist but it needs some further thoughts. We will definitely use October's native import/export functionality.

We do however need to solve a few problems:

  • How are images imported
  • How is the csv formatted to allow for products and variants to be created
  • How is the description text imported (might be html)
  • How are property values imported

I didn't look into this feature yet so some of these points might be very easy to fix. There might be other problems I could not think of yet.

A first iteration of the feature might be to simply import the base data and all further info has to be entered manually. This would already take away the burden of creating every product by hand.

I'll leave this issue open for others to track progress on this feature.

tobias-kuendig avatar Jan 15 '19 16:01 tobias-kuendig

Ok great. I was thinking making a sample CSV template with the required fields and making it accessible via a download link could be a helpful solution.

StanleyBonhomme avatar Jan 15 '19 17:01 StanleyBonhomme

Hello, it will be a way to import PrestaShop products ? It's be very very interesting to do that but there is a lot of problematics to me:

  • The multishop system (keep it or not)
  • The combinations and images system
  • Product with language (compatible with Translate plugin https://octobercms.com/plugin/rainlab-translate) I know well PrestaShop, i can help if you want ;)

Thanks to you !

PrestaSafe avatar Jan 30 '19 12:01 PrestaSafe

I feel like importers for specific shop systems should be a separate plugin and not part of the core. We will add an export/import format that is mall specific. We cannot regard every other shop system out there.

If you want to implement a PrestaShop importer in a separate plugin feel free to contact us for support.

tobias-kuendig avatar Feb 02 '19 11:02 tobias-kuendig

I think it is good to look at how other e-commerce systems achieved this.

Having this future would help many people like me to move their shops into OC ASAP. If anybody else is interested in this feature maybe we can help and fund the creator to accelerate the work and focus more on this feature?

Almusamim avatar Feb 12 '19 22:02 Almusamim

We can start by making a basic product import/export.. I will play with this in the weekend

anyway thanks for the plugin great work 🥇

Almusamim avatar Feb 12 '19 22:02 Almusamim

@tobias-kuendig any news on this feature or is it still on the side for now?

darkwoods- avatar Jul 22 '19 17:07 darkwoods-

As long as we don't have a paid project that needs this feature I won't be able to work on it. I'm happy to discuss possible implementations or accept (partial) PRs for this feature, though.

tobias-kuendig avatar Jul 23 '19 06:07 tobias-kuendig

Thank you for your input.

This is indeed a feature on our wishlist but it needs some further thoughts. We will definitely use October's native import/export functionality.

We do however need to solve a few problems:

  • How are images imported
  • How is the csv formatted to allow for products and variants to be created
  • How is the description text imported (might be html)
  • How are property values imported

I didn't look into this feature yet so some of these points might be very easy to fix. There might be other problems I could not think of yet.

A first iteration of the feature might be to simply import the base data and all further info has to be entered manually. This would already take away the burden of creating every product by hand.

I'll leave this issue open for others to track progress on this feature.

I actually made an extension plugin some time ago for this.

  • images are uploaded with full URLs
  • To avoid duplicates and to update existing products i used the user_defined_id but Mall allows different products to have the same user_defined_id when it should be unique.. Either way we can easily use the IDs if we want to or make a option to choose between the two.
  • As for Variants I was thinking I either make a product variant import/export for itself or just adding another column for the product import/export where you add the related product by either ID or the user_defined_id
  • description text etc can be imported in html
  • Categories and brand will be created if they don't exist as for having multiple categories we can use | delimiter like this: Category|Category 2 etc.
  • additional properties we can use json.. maybe not the best way to do it but it works..

Anyway it still needs some testing and code cleansing but if you are interested I can add it on github and maybe you can have a look and advise me on few things or even help me out a little :p

And even if someone desperately needs this feature.. this might help as most things works but maybe not for variants as yet!

Almusamim avatar Aug 31 '19 08:08 Almusamim

Yaay, for sure throw it on github.

amdad avatar Sep 03 '19 01:09 amdad

@Almusamim: is this draft of extension plugin for import published somewhere?

RobertCh2 avatar Jun 10 '20 15:06 RobertCh2

Hello any news about import products feature/plugin? I really need a way to import products..

skacco avatar Aug 05 '20 12:08 skacco

No news. But you have all of the featureset of October's importer available to you:

https://octobercms.com/docs/backend/import-export

tobias-kuendig avatar Aug 05 '20 12:08 tobias-kuendig

Hi all,

I've just make a plugin to import (update) or export products data. ⚠ Please note that it does NOT allow you to add products but to update existing products.

https://github.com/Hounddd/wn-mallimportexport-plugin

damsfx avatar Sep 24 '21 17:09 damsfx