Skip to content
  • Categories
  • Tags
  • Popular
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (Flatly)
  • No Skin
Collapse

Odoo 中文社区

  1. Home
  2. Categories
  3. Odoo 新手求助
  4. 导入产品时出错

导入产品时出错

Scheduled Pinned Locked Moved Odoo 新手求助
8 Posts 2 Posters 9.0k Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • T Offline
    T Offline
    tianciyx
    wrote on last edited by
    #1

    我将商品的csv文件导入在产品出错,提示如下:
    Error trying to import this record:
    active: 1
    price_margin: 1.0
    default_code: 2033062
    price_extra: 0.0

    Error Message:
    ERROR: null value in column "procure_method" violates not-null constraint

    insert into "product_template" (id,perm_id,"uos_coeff","supply_method","sale_delay","list_price","name","produce_delay","sta
    是否是说成本计算方法字段值不能为空,但我的商品csv文件中成本计算方法值已设为stanard,商品csv文件为:
    名称,分类,编码,产品类型,采购方式, 采购方式,标准价格,基本价格,成本计算方法,计量类型
    威立仕单杯架,厨卫商品,2033062,product,make_to_order,buy,21,60,standard, fixed
    还有,我安装的是中文版0.33,如何才能打开数据库看表product_template的内容
    [table=98%][tr][td]
    [/td][td]
    [/td][td]
    [/td][td]
    [/td][td]
    [/td][td]
    [/td][td]
    [/td][td]
    [/td][td]
    [/td][td]
    [/td][/tr][/table]

    [[i] 本帖最后由 tianciyx 于 2008-1-20 12:15 编辑 [/i]]

    1 Reply Last reply
    0
    • T Offline
      T Offline
      tianciyx
      wrote on last edited by
      #2

      怎么没人回复呢,那有谁知道如何在中文版0.33中查看数据库表结构及内容么?

      1 Reply Last reply
      0
      • wjfonhandW Offline
        wjfonhandW Offline
        wjfonhand
        wrote on last edited by
        #3

        名称,分类,编码,产品类型,采购方式, 采购方式,标准价格,基本价格,成本计算方法,计量类型
        ERROR: null value in column "procure_method" violates not-null constraint
        您没发现采购方式重复了么?

        GoodERP -- Odoo China fork

        1 Reply Last reply
        0
        • T Offline
          T Offline
          tianciyx
          wrote on last edited by
          #4

          但产品表单中是有二个采购方式,而且都是必填字段,那导入时我应将字段名改为什么呢?

          1 Reply Last reply
          0
          • wjfonhandW Offline
            wjfonhandW Offline
            wjfonhand
            wrote on last edited by
            #5

            恩,这个应该是翻译的问题。

            第一个采购方式应该是生产模式,按单生产还是按库存生产,你的make_to_order应该是对的。

            第二个采购方式应该是获取方式,生产还是采购,你试一下吧。

            一般做导入之前先导出,把导出的文件做模板改,就不容易出错了。

            good luck

            GoodERP -- Odoo China fork

            1 Reply Last reply
            0
            • T Offline
              T Offline
              tianciyx
              wrote on last edited by
              #6

              确实是先导出,有两个采购方式,一个的值是make_to_order,一个的值是buy,那我导入时应将其中的某一个字段名更改为什么呢

              1 Reply Last reply
              0
              • T Offline
                T Offline
                tianciyx
                wrote on last edited by
                #7

                看来只有去掉后面那个采购方式导入了

                1 Reply Last reply
                0

                • Login

                • Don't have an account? Register

                • Login or register to search.
                • First post
                  Last post
                0
                • Categories
                • Tags
                • Popular
                • Users
                • Groups