Changing product attributes retroactively via upload

From GLOBALG.A.P. Wiki
Jump to navigation Jump to search

This wiki article will enable you to change product attributes retroactively which can save huge amounts of manual work. It is very important that you follow this guide literally as otherwise the manual workload would even increase or data could be seriously corrupted.

If you want an overview over the product upload sheet, please refer first to Product upload.

Generelly, you can use the product upload sheet to add a product(action 1), accept a product (action 2), certify products (action 3), for product suspension (action 4) and for lifting product suspension (action 5).

If you wish to change the attributes of the products, you can do so via the product upload sheet using action 8. Note, the Status of the product will not be changed with Action 8.

IMPORTANT: !!Action 8 should be used very carefully and just in the below mentioned way in order to avoid unwanted consequences / data corruption!!

Please note that the following columns are compulsory for Action 8.

• GGN, Product key, action, current cycle, next cycle, O-Key CB/PG, scheme ID, option (columns A-H)

• audit type (column R); compulsory only when certified

• parallel_ownership, parallel_production (X,Y)

• produce handling and harvest included (column O,P, Q) - column O only applicable for Aquaculture, Livestock and GRASP; Column P applicable for crop based

!!Please note that when the attributes (X,Y, O, P and Q) are left empty the Status will jump back to “not selected” in the system in case there was a different value (e.g. for GRASP under column O yes(1) or no(0)) before!!

Action 8 enables you to execute specific changes as mentioned below.

1. For a product with the status “non confirmed” you can:

• Change Scheme ID for option 1

• Change Option

• Change CB/PG

• Change the Quantity

• Change the Attribute

2. For a product with the status “Acceptance” you can:

• Change the Quantity

• Change the Attribute

3. For a product with the status “Certified you can

• Change the Quantity

• Change the Attribute