Prijzen in bulk aanpassen (Drupal Commerce)

Inventaris

Op database-niveau

Waarschijnlijk moet je dan twee tabellen aanpassen + join om de juiste artikelen te identificeren:

• field_data_commerce_price
• field_revision_commerce_price

VBO

Mbv. VBO - Gedoe + per pagina moet je akkoord geven [1]

Commerce Feeds

Mbv. Commerce Feeds [2]

Database-niveau

Kijk & huiver:

##########################################
# Update field
##########################################

# Test
###############
#
# select
# 
#     field_data_commerce_price.commerce_price_amount,
#     commerce_product.product_id, 
#     commerce_product.revision_id, 
#     commerce_product.sku, 
#     commerce_product.title
#     
# from field_data_commerce_price
# join commerce_product on field_data_commerce_price.entity_id = commerce_product.product_id
# 
# where type like "product";

# Update
#########
#
update field_data_commerce_price
join commerce_product on field_data_commerce_price.entity_id = commerce_product.product_id

set field_data_commerce_price.commerce_price_amount = 1.1* field_data_commerce_price.commerce_price_amount
	
where type like "product";

##########################################
# Update revision
##########################################

# Test
##############
#
# select
# 
#     field_revision_commerce_price.commerce_price_amount,
#     commerce_product.product_id, 
#     commerce_product.revision_id, 
#     commerce_product.sku, 
#     commerce_product.title
#     
# from field_revision_commerce_price
# join commerce_product on field_revision_commerce_price.entity_id = commerce_product.product_id
# 
# where type like "product";

# Update
########
#
update field_revision_commerce_price
join commerce_product on field_revision_commerce_price.entity_id = commerce_product.product_id

set field_revision_commerce_price.commerce_price_amount = 1.1* field_revision_commerce_price.commerce_price_amount
	
where type like "product";