Re: Update many items in a column at once or individually

donstephen — Mon, 24 Aug 2015 06:29:32 GMT

Hi Aardvark,

I understand you would like to update items from a table with a large amount of data. May I know what kind of database and/or webservices are you using? You may want to check out Qdabra's DBXL if you are working with 200k items. Via DBXL web services, we can create a dashboard to query items based on a filter, and update the documents using EditDocuments web service operation.

Regards,

Update many items in a column at once or individually

aardvark — Fri, 21 Aug 2015 16:07:16 GMT

I have this issue:
to simplify -
I have 5 orders I have 5 items that have varying prices and I have 5 customers. Not all customers sell these items. I also have different shipping addresses and customer contacts based on order numbers. Users can update pricing, contacts and shipping info.
I want a way for the user to update contact info as a group or pricing individually. I actually have 200k + rows of data.

Orders	Items	price	customers	contact	Ship Contact	shipto
111	a	0.2	Shop	Bill A	Zach J	125 Main
111	b	1	Shop	Bill A	Zach J	125 Main
111	c	0.05	Shop	Bill A	Zach J	125 Main
111	d	1	Shop	Bill A	Zach J	125 Main
111	e	0.05	Shop	Bill A	Zach J	125 Main
222	d	0.9	Shop	Bob S	Carol F	126 Main
222	e	1.85	Shop	Bob S	Carol F	126 Main
333	a	0.03	Shop	Sue T	Sam V	128 Main
333	e	9.45	Shop	Sue T	Sam V	129 Main

Example for order number 111
Change contact 'Bill A' to 'William G' And shipto to '345 Center' (in all columns at one time) and price for item d to .90

What is the best way to achieve this?

Any help is appreciated

Newbie Questions

Re: Update many items in a column at once or individually

Update many items in a column at once or individually