Suggestion on how to make import and export of products using csv from admin panel?

[Sathish Anton]

Hi,

Please provide Suggestion on how to make import and export of products using csv from admin panel?

Thanks and Regards,

Sathish Anton. A

[Ken Bolton]

Hi Sathish,

What have you tried so far? There is plenty of documentation out there
on working with Django and CSV, and plenty more on Django's admin
interface.

If you are not using Python 3, I can caution you to use the unicodecsv
module: https://pypi.python.org/pypi/unicodecsv.

hth,
ken

> --
> You received this message because you are subscribed to the Google Groups
> "Mezzanine Users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to mezzanine-use...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

[Stephen McDonald]

There's a potentially outdated CSV import script here:

https://github.com/stephenmcd/cartridge/blob/master/cartridge/shop/management/commands/product_db.py

That should get you 90% of the way

--

You received this message because you are subscribed to the Google Groups "Mezzanine Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mezzanine-use...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Stephen McDonald
http://jupo.org

[Eduardo Rivas]

Adding to the suggestions, I've used django-import-export in the past
with satisfactory results. It does admin integration out of the box and
let's you pick different import/export formats (Excel, csv, json, etc).
I've only used it to export records; can't speak for the importing part.
The docs will guide you all the way through.

https://django-import-export.readthedocs.io/en/latest/

[Sathish Anton]

Hi,

The import seems to be an issue with both Product_db command and django-import-export.

Can some one explain exact shell  commands that would be required to add a product to

   1. shop category

   2. shop/subcategory

from python manage.py shell or 

some other sugestion on utils available.

Thanks and Regards,

Sathish Anton. A

[Eduardo Rivas]

What have you tried so far? What errors are you getting?

[Sathish Anton]

Hi,

W.r.t Product_db command i tried the following with single django pony sample data loaded with createdb.

1. python manage.py product_db --export cur.csv

2. Deleted the single django product using admin panel manualy so that there wont be any issues with indexing or sku.

3. python manage.py product_db --import cur.csv  

    

The errors observed are,

  1. Additional empty shop category gets created as the field for subcategory is blank in csv.

  2. There seems to issues with image path. Probaly i have to adust the following parametes for this in product_db.py

      LOCAL_IMAGE_DIR, 

      SITE_MEDIA_IMAGE_DIR

      PRODUCT_IMAGE_DIR

or probaly some documnetation on what values should be set should help.

I also tried django-import-export util by following the example mentioned in read docs

1. I was able to see admin panel having import and export options.,

2. Export of data was succesfull.

3. Import was successful was sucessfull but database was corrupted.

Probaly i need an understanding of mandatory fields required to add a product to make this work.

Thanks,

Sathish Anton. A

[Sathish Anton]

Hi,

This is what i did with django-import-export

   1. pip install django-import-export

  2.# add to settings.py

INSTALLED_APPS = (
    ...
    'import_export',
)

3. Modified lib/python2.7/site-packages/cartridge/shop and added following code

from import_export import resources
from import_export.admin import ImportExportModelAdmin
from import_export.admin import ImportExportMixin, ImportMixin, ExportActionModelAdmin

class CategoryAdmin(PageAdmin):

!class CategoryAdmin(ExportActionModelAdmin, PageAdmin):

class ProductVariationAdmin(admin.TabularInline):

!class ProductVariationAdmin(ImportMixin, admin.TabularInline):

class ProductImageAdmin(TabularDynamicInlineAdmin):

!class ProductImageAdmin(ImportMixin, TabularDynamicInlineAdmin):

+class ProductResource(resources.ModelResource):

+    class Meta:
+        model = Product

class ProductAdmin(ImportExportModelAdmin, DisplayableAdmin):

!class ProductAdmin(ImportExportModelAdmin, DisplayableAdmin):

      +resource_class = ProductResource

1. python manage.py runserver

2. http://127.0.0.1:8000/admin/shop/product/ 

    Import export options are available in admin.

3. First do an export of csv file say current.csv

4. Delete Django pony sample product.

5. Do import of same current.csv 

The Product gets added without any errors.

However the errors observed are

1. The variation fields does not gets filled up.

2. Multiple images are not loaded.

3. Unit price and sales price are not updated.

I am not sure how the product variation are to be handled.

Thanks,

sathish Anton. A

[Sathish Anton]

Hi,

The management command product_db works with some changes made.

1. mkdir "/tmp/orig/product" where LOCAL_IMG_DIR="/tmp/orig"

2. Copy all your imagefiles to "/tmp/orig/product"

3. Make small changes as mentioned in the new product_db.py attached with this post.

Repeat test:

1. python manage.py product_db --export sample.csv

2. Delete the Django pony product manualy from the admin panel.

3. Import the same file

   python manage.py product_db --import sample.csv

Thanks and regards,

Sathish Anton. A

[Sathish Anton]

Hi,

Please let me know  if

You have any idea on lncluding the inline models

inlines = (ProductImageAdmin, ProductVariationAdmin)

 in django-import-export.

Thanks,

Sathish Anton. A

On Saturday, April 30, 2016 at 9:30:55 PM UTC+5:30, Eduardo Rivas wrote:

[Eduardo Rivas]

You will need to create separate imports for separate models. At that
point it might be better to create your own admin view to import several
models at a time, calling the individual model importer in the right order.

[Sathish Anton]

Hi,

Here is a method to override django-import-export functions with product_db import export function.

1. pip install django-import-export

2. Add to# settings.py

INSTALLED_APPS = (
    ...
    'import_export',
)

3. Add image files to /tmp/orig/product

4. Make changes to the /home/sathish/impexp/lib/python2.7/site-packages/cartridge/shop/admin.py as in the attached file.

5. python manage.py runserver

6. Enter admin panel

7. click on products

8. You will find import and export buttons in admin panel

9. Do export of file using csv format as csv format is only supported now for importing.

10. save the downloaded file.

11. Delete the single django pony product for testing purpose.

12. Do import of same csv file.

13. Review wont produce any output as import function is overridden by product_db import.

14. confirm submit. and products will be added as done by product_db.

Thanks and Regards,

Sathish Anton. A

+919176613030

On Friday, April 29, 2016 at 11:36:33 PM UTC+5:30, Sathish Anton wrote:

[Eduardo Rivas]

Glad to see you figured it out.

The only suggestion I have is that you should avoid editing Cartridge
source code, and instead register your own customized admin class in
your project. That way future Cartridge updates won't break your code
(as easily) and you know all your customizations live in your project.