Lance Edgar
57d3a21e43
fix: improve logic for matching CORE stock purchase to Rattail payment
...
we were already "trying" to match on date only, but only as a sort of
fallback. now we still try "exact" date/time match first but then
also an explicit date match, before other fallback logic
2024-08-19 11:30:44 -05:00
Lance Edgar
b7ad6ba37f
fix: fix CORE op model reference
2024-07-14 08:36:41 -05:00
Lance Edgar
345d5348c3
fix: refactor config.get_model()
=> app.model
...
per rattail changes
2024-07-13 09:52:53 -05:00
Lance Edgar
03bc03c9b8
fix: avoid error when CORE API gives record with no upc
2024-07-10 10:22:46 -05:00
Lance Edgar
e56cdf1802
fix: fix employee status when importing from CORE API
2024-07-04 21:33:38 -05:00
Lance Edgar
1b04b4097c
fix: add Employee support for CORE API -> Rattail import/datasync
2024-07-04 18:29:05 -05:00
Lance Edgar
4752409a45
fix: misc. improvements for CORE API importer, per flaky data
...
handle some edge cases better; let config dictate whether some
warnings should be logged etc.
2024-07-04 13:23:51 -05:00
Lance Edgar
dca2c1bfe2
fix: add command to install mysql triggers for CORE office_op
DB
...
for use with datasync. this also adds datasync support for
ProductCost preference
2024-07-03 18:25:18 -05:00
Lance Edgar
2f22be6e7e
fix: improve ProductCost sorting for import from CORE API
...
this hopefully ensures a more consistent preference order, fewer diffs
2024-07-02 22:44:55 -05:00
Lance Edgar
eb9a1ae4f0
fix: include person_uuid
for Member import from CORE API
...
so we correctly associate Customer / Person / Member
2024-07-02 13:58:47 -05:00
Lance Edgar
76b183676d
Misc. fixes for CORE API -> Theo importers
...
based on a certain sample data set, not sure why these didn't come up
before? oh well
2024-05-09 20:52:08 -05:00
Lance Edgar
439bd50deb
Add account_holder_full_name
for CORE -> Rattail customer import
2023-11-15 11:38:33 -06:00
Lance Edgar
b6e21f52ee
Import Store, ProductCost from CORE DB
...
and tweak API importer accordingly
2023-10-20 14:37:25 -05:00
Lance Edgar
67861522eb
Import the Product.not_for_sale
flag from CORE-POS
2023-10-19 19:13:22 -05:00
Lance Edgar
5ac3a3d82c
Import product sale pricing from CORE
...
this almost certainly needs improvements for POS sake
2023-10-18 21:28:17 -05:00
Lance Edgar
98da72ea14
Avoid false match when importing equity payments from CORE
2023-10-15 17:54:46 -05:00
Lance Edgar
2f3926f899
Include person_uuid
when importing members from CORE DB
...
otherwise can cause duplicate person records, e.g. if customers also
are imported from CORE
2023-10-14 17:46:49 -05:00
Lance Edgar
d08c475223
Add customer, member importers from CORE DB
...
API is just not cutting it, need more flexibility
2023-10-12 10:34:46 -05:00
Lance Edgar
124a510c17
Import tax rate, food stamp flag for departments from CORE
2023-10-11 18:36:51 -05:00
Lance Edgar
8929d678fa
Avoid error if CORE has invalid products.tax
FK
2023-10-08 17:35:46 -05:00
Lance Edgar
cf90ca5704
Add importer for tax rates from CORE
2023-10-07 16:28:12 -05:00
Lance Edgar
117442f8db
Add employee importer for CORE -> Rattail, and CORE cashier auth handler
2023-10-01 19:48:52 -05:00
Lance Edgar
f61ae7a7e0
Add tender importer from CORE; apply tender in CORE POS batch
...
still some work to be done yet but getting there
2023-09-27 17:14:28 -05:00
Lance Edgar
7a18dc20ce
Do not raise error if CORE equity payment not found in rattail
2023-09-19 07:08:35 -05:00
Lance Edgar
6e1d2544c8
Fix bug when fetching corepos handler
2023-09-19 06:49:30 -05:00
Lance Edgar
ebdb658a2c
Make CORE API client via app handler, not deprecated function
2023-09-18 08:12:20 -05:00
Lance Edgar
1d1cb5fb3c
Make CORE -> Rattail equity import a bit smarter re: datetime
...
if we add new equity to CORE, we can't know its timestamp for 100%
sure, and may need a "fuzzy" match when importing it back later
2023-09-15 10:35:44 -05:00
Lance Edgar
4bff0832e8
Use "complete" composite key for importing CORE equity payments
2023-09-13 22:13:37 -05:00
Lance Edgar
60bc6dd236
Add CORE-specific datetime for equity payments
...
in case payments are added to CORE on a later date, want to keep
original timestamp separate
2023-09-13 21:29:16 -05:00
Lance Edgar
64048db92f
Import member first/last name from CORE API
2023-09-13 13:15:25 -05:00
Lance Edgar
bf74ba8108
Ignore non-CORE equity payments when importing from CORE
...
hopefully a good idea..?
2023-09-07 20:58:35 -05:00
Lance Edgar
a57f29fe1a
Add support for importing MemberEquityPayment from CORE-POS DB
...
SQL only, no API for now
2023-09-07 18:18:38 -05:00
Lance Edgar
b6e4ad2a21
Import Member.corepos_account_id
from CORE
2023-06-18 17:19:43 -05:00
Lance Edgar
3cef682a75
More tweaks for CORE <-> Rattail member sync
2023-06-11 21:05:51 -05:00
Lance Edgar
788efbd114
Let handler cache members from CORE API, for multiple importers
2023-06-11 15:26:27 -05:00
Lance Edgar
2ca9cd8f76
Fix how customerAccountID is imported from CORE API
...
geez.
also optimize joinedloads when fetching Rattail member data for CORE
export
2023-06-11 15:21:30 -05:00
Lance Edgar
914fcbe192
Add customer "account holder" support for CORE -> Rattail
2023-06-11 14:53:14 -05:00
Lance Edgar
87bd1faa58
Make some importer logic datasync-friendly
2023-06-10 21:58:24 -05:00
Lance Edgar
7489d4a4a9
Add phone/email support in CORE -> Rattail importer for CustomerShopper
2023-06-10 21:10:09 -05:00
Lance Edgar
76b0791831
Add support for Customer address fields in CORE -> Rattail
2023-06-10 20:27:12 -05:00
Lance Edgar
13e5f2a801
Add version importer for CoreCustomerShopper
model
2023-06-10 18:01:24 -05:00
Lance Edgar
660637522d
Add CustomerShopper.corepos_customer_id
and refactor importers
...
removes phone/email support for now..also change how we handle
default/empty values for member start/end date..
2023-06-10 14:35:08 -05:00
Lance Edgar
86a8e2d241
Detect bad memtype number early, for CORE API -> Rattail import
...
to avoid false diffs when we give a bad value
2023-06-10 13:06:18 -05:00
Lance Edgar
a45d28cd6f
Add initial/basic CustomerShopper importer for CORE -> Rattail
...
this replaces previous importers for Person and CustomerPerson
no contact info support just yet..need to decide where to put that
2023-06-07 16:39:57 -05:00
Lance Edgar
2c38e4d5d3
Import membership types from CORE API
2023-06-06 13:14:36 -05:00
Lance Edgar
dde729b959
Import the Member.active
flag from CORE API
2023-06-06 11:45:35 -05:00
Lance Edgar
bfc52a6fb3
Make card_number
more central for CORE API -> Rattail importers
...
let's track that as (effectively) `Customer.corepos_card_number` and
use that when possible for importer key
2023-06-05 20:45:45 -05:00
Lance Edgar
519ed0a594
Avoid deprecated import for OrderedDict
2023-05-05 01:48:39 -05:00
Lance Edgar
63a1172408
Update usage of short_session()
per upstream changes
2022-08-21 20:00:15 -05:00
Lance Edgar
7eb7c25172
Fix datasync bug for CORE API -> Rattail
2022-08-21 11:33:51 -05:00